DBA Data[Home] [Help]

APPS.BEN_CWB_POST_PROCESS dependencies on PER_ALL_ASSIGNMENTS_F

Line 657: FROM per_all_assignments_f asg,

653: , v_effective_date DATE
654: )
655: IS
656: SELECT decode(piv.uom,NULL,2,'M',nvl(curr.PRECISION,2),5) PRECISION
657: FROM per_all_assignments_f asg,
658: per_pay_bases ppb,
659: pay_input_values_f piv,
660: pay_element_types_f pet,
661: fnd_currencies curr

Line 877: FROM per_all_assignments_f asg

873: SELECT asg.assignment_id
874: , asg.pay_basis_id
875: , ppp.proposed_salary_n
876: , ppp.object_version_number
877: FROM per_all_assignments_f asg
878: , per_pay_bases ppb
879: , per_pay_proposals ppp
880: , ben_cwb_person_info per
881: WHERE per.group_per_in_ler_id = v_group_per_in_ler_id

Line 1159: from per_all_assignments_f asgn

1155: , asgn.ass_attribute27
1156: , asgn.ass_attribute28
1157: , asgn.ass_attribute29
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