ENGINATICS
SYSTEM_ADMINISTRATOR
SYSADMIN
8E2FF36EDE9B79D2E0530100007F1FF2
PER Business Group
Y
select
pbg.name value,
hla.location_code description
from
per_business_groups pbg,
hr_locations_all hla
where
pbg.location_id=hla.location_id(+)
order by
pbg.name
US
996E310F1501F0E4E053B46B63583DA4
select
papf.employee_number,
papf.first_name,
papf.last_name,
papf.full_name,
pbg.name business_group,
paaf.supervisor_id,
(select x.full_name from per_all_people_f x where x.person_id=paaf.supervisor_id and paaf.effective_start_date between x.effective_start_date and x.effective_end_date) supervisor_name,
fct.currency_code,
ppp_old.proposed_salary_n old_sal,
ppp_new.proposed_salary_n new_sal,
ppp_new.change_date,
pj.name current_job,
pg.name current_grade,
pap.name current_position,
papf.person_id
from
(select papf.* from per_all_people_f papf where :effective_date between papf.effective_start_date and papf.effective_end_date) papf,
per_business_groups pbg,
(select paaf.* from per_all_assignments_f paaf where :effective_date between paaf.effective_start_date and paaf.effective_end_date) paaf,
per_jobs pj,
per_grades pg,
per_all_positions pap,
fnd_currencies_tl fct,
per_pay_proposals ppp_old,
per_pay_proposals ppp_new
where
1=1 and
papf.business_group_id=pbg.business_group_id and
papf.person_id=paaf.person_id and
paaf.assignment_type='E' and
paaf.primary_flag='Y' and
paaf.job_id=pj.job_id(+) and
paaf.grade_id=pg.grade_id(+) and
paaf.position_id=pap.position_id(+) and
paaf.assignment_id=ppp_old.assignment_id and
ppp_new.assignment_id=paaf.assignment_id and
per_saladmin_utility.get_currency(ppp_old.assignment_id,ppp_old.change_date)=fct.name and
fct.language=userenv('LANG') and
ppp_new.last_change_date=ppp_old.change_date and
ppp_new.change_date=(select max(x.change_date) from per_pay_proposals x where x.assignment_id=paaf.assignment_id)
Y
AR
PER Employee Salary Change
استعلام للحصول على آخر تفاصيل تغيير الراتب للموظفين.
يمكن إضافة:
ما إذا كان سيتم النظر إلى تغيير الراتب الأخير فقط؟
أو سجل تغيير الراتب .... إذا كانت الإجابة بنعم ، فإن الشرط الأخير في حيث يتم إضافة / إزالة شرط ديناميكيًا
D
PER Employee Salary Change
Abfrage, um die Details der letzten Gehaltsänderung für Mitarbeiter zu erhalten.
Kann hinzufügen:
ob nur die letzte Gehaltsänderung betrachtet werden soll?
oder Gehaltsänderungshistorie.... Wenn ja, dann soll die letzte Bedingung in der Where-Klausel dynamisch hinzugefügt/entfernt werden
E
PER Employee Salary Change
Consulta para obtener los detalles del último cambio de salario de los empleados.
Puede añadir:
si desea ver sólo el cambio de salario reciente
o el historial de cambios salariales.... Si es así, entonces la última condición en la cláusula where debe ser añadida/eliminada dinámicamente
F
PER Employee Salary Change
Demande d'informations sur le dernier changement de salaire pour les employés.
Peut ajouter :
s'il faut se contenter d'examiner la récente évolution des salaires ?
ou l'historique des changements de salaire.... Si oui, alors la dernière condition dans laquelle la clause doit être dynamiquement ajoutée/supprimée
I
PER Employee Salary Change
Query per ottenere i dettagli dell'ultimo cambio di stipendio per i dipendenti.
Può aggiungere:
se guardare solo il recente cambiamento di stipendio?
o cronologia dei cambiamenti di stipendio.... Se sì, allora l'ultima condizione nella clausola where da aggiungere/rimuovere dinamicamente
JA
PER Employee Salary Change
従業員の最後の給与変更の詳細を取得するためのクエリ。
追加することができます。
最近の給与明細だけを見るのか、転職履歴だけを見るのか。
それとも給与変更履歴....はいの場合は、動的に追加/削除されるWHERE句の最後の条件
KO
PER Employee Salary Change
사원에 대한 마지막 급여 변경 세부 사항을 가져 오려면 질의하십시오.
다음을 추가 할 수 있습니다.
최근 급여 변경 만 볼 것인지 여부?
또는 급여 변경 내역 .... 예인 경우 동적으로 추가 / 제거 할 where 절의 마지막 조건
PTB
PER Employee Salary Change
Consulta para obter os últimos detalhes de mudança salarial para os funcionários.
Pode acrescentar:
se olhar apenas para a recente mudança salarial?
ou o histórico de mudança salarial.... Se sim, então a última condição em que a cláusula a ser dinamicamente adicionada/removida
RU
PER Employee Salary Change
Запрос на получение последней информации об изменении зарплаты для сотрудников.
Могу добавить:
стоит ли смотреть только на недавнее изменение зарплаты?
или историю изменения зарплаты.... Если да, то последнее условие, в котором нужно динамически добавлять/удалять пункт
S
PER Employee Salary Change
Fråga för att få de senaste uppgifterna om lönebyte för anställda.
Kan Adda:
om man bara tittar på den senaste löneförändringen?
eller löneändringshistorik .... Om ja, då är det sista villkoret där klausulen ska läggas till / tas bort dynamiskt
TR
PER Employee Salary Change
Çalışanlar için son Maaş değişikliği ayrıntılarını almak için sorgulama.
Ekleyebilir:
sadece son maaş değişikliğine bakıp bakmamak?
veya maaş değişikliği geçmişi .... Evet ise, maddenin dinamik olarak ekleneceği / kaldırılacağı son koşul
US
PER Employee Salary Change
Query to get the last Salary change details for employees.
Can add:
whether to look at just the recent salary change?
or salary change history.... If yes, then the last condition in where clause to be dynamically added/removed
ZHS
PER Employee Salary Change
查询获取员工最后一次薪资变动详情。
可以补充。
是只看最近的工资变化？
还是薪资变动历史....如果是，那么要动态添加/删除where子句中的最后一个条件。
Enginatics
1=1
:effective_date
1
10
1=1
pbg.name=:business_group
LOV
PER Business Group
8E2FF36EDE9B79D2E0530100007F1FF2
Y
select
pbg.name value,
hla.location_code description
from
per_business_groups pbg,
hr_locations_all hla
where
pbg.location_id=hla.location_id(+)
order by
pbg.name
F
Groupe d'entreprises
US
Business Group
2
200
:effective_date
Date
sysdate
Y
F
Date d'entrée en vigueur
US
Effective Date