DBA Data[Home] [Help]

APPS.BEN_CWB_POST_PROCESS dependencies on PER_JOBS_TL

Line 381: , per_jobs_tl job

377: , per.ass_attribute28
378: , per.ass_attribute29
379: , per.ass_attribute30
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

Line 1147: , per_jobs_tl job

1143: , asgn.ass_attribute28
1144: , asgn.ass_attribute29
1145: , asgn.ass_attribute30
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

Line 1169: , per_jobs_tl job

1165: , pos.name position
1166: , grade.name grade
1167: , people_group.group_name
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