DBA Data[Home] [Help]

APPS.BEN_CWB_POST_PROCESS dependencies on PAY_PEOPLE_GROUPS

Line 395: , pay_people_groups ppl_groups

391: FROM ben_cwb_person_info per
392: , per_jobs_tl job
393: , hr_all_positions_f_tl pos
394: , per_grades_tl grades
395: , pay_people_groups ppl_groups
396: WHERE per.group_per_in_ler_id = v_group_per_in_ler_id
397: AND job.job_id(+) = per.job_id
398: AND job.language(+) = userenv('LANG')
399: AND pos.position_id(+) = per.position_id

Line 1163: , pay_people_groups people_group

1159: from per_all_assignments_f asgn
1160: , per_jobs_tl job
1161: , hr_all_positions_f_tl pos
1162: , per_grades_tl grade
1163: , pay_people_groups people_group
1164: where assignment_id = v_assignment_id
1165: and v_effective_date between effective_start_date and effective_end_date
1166: and job.job_id(+) = asgn.job_id
1167: and job.language(+) = userenv('LANG')

Line 1185: , pay_people_groups people_group

1181: from ben_transaction asgn
1182: , per_jobs_tl job
1183: , hr_all_positions_f_tl pos
1184: , per_grades_tl grade
1185: , pay_people_groups people_group
1186: where asgn.transaction_id = v_transaction_id
1187: and asgn.transaction_type = v_transaction_type
1188: and job.job_id(+) = asgn.attribute5
1189: and job.language(+) = userenv('LANG')