DBA Data[Home] [Help]

APPS.BEN_CWB_POST_PROCESS dependencies on PER_GRADES_TL

Line 394: , per_grades_tl grades

390: , per.ass_attribute30
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')

Line 1162: , per_grades_tl grade

1158: , asgn.ass_attribute30
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

Line 1184: , per_grades_tl grade

1180: , people_group.group_name
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