DBA Data[Home] [Help]

APPS.BEN_CWB_POST_PROCESS dependencies on PAY_PEOPLE_GROUPS

Line 384: , pay_people_groups ppl_groups

380: FROM ben_cwb_person_info per
381: , per_jobs_tl job
382: , hr_all_positions_f_tl pos
383: , per_grades_tl grades
384: , pay_people_groups ppl_groups
385: WHERE per.group_per_in_ler_id = v_group_per_in_ler_id
386: AND job.job_id(+) = per.job_id
387: AND job.language(+) = userenv('LANG')
388: AND pos.position_id(+) = per.position_id

Line 1150: , pay_people_groups people_group

1146: from per_all_assignments_f asgn
1147: , per_jobs_tl job
1148: , hr_all_positions_f_tl pos
1149: , per_grades_tl grade
1150: , pay_people_groups people_group
1151: where assignment_id = v_assignment_id
1152: and v_effective_date between effective_start_date and effective_end_date
1153: and job.job_id(+) = asgn.job_id
1154: and job.language(+) = userenv('LANG')

Line 1172: , pay_people_groups people_group

1168: from ben_transaction asgn
1169: , per_jobs_tl job
1170: , hr_all_positions_f_tl pos
1171: , per_grades_tl grade
1172: , pay_people_groups people_group
1173: where asgn.transaction_id = v_transaction_id
1174: and asgn.transaction_type = v_transaction_type
1175: and job.job_id(+) = asgn.attribute5
1176: and job.language(+) = userenv('LANG')