DBA Data[Home] [Help]

APPS.BEN_CWB_POST_PROCESS dependencies on PER_ALL_ASSIGNMENTS_F

Line 646: FROM per_all_assignments_f asg,

642: , v_effective_date DATE
643: )
644: IS
645: SELECT decode(piv.uom,NULL,2,'M',nvl(curr.PRECISION,2),5) PRECISION
646: FROM per_all_assignments_f asg,
647: per_pay_bases ppb,
648: pay_input_values_f piv,
649: pay_element_types_f pet,
650: fnd_currencies curr

Line 865: FROM per_all_assignments_f asg

861: SELECT asg.assignment_id
862: , asg.pay_basis_id
863: , ppp.proposed_salary_n
864: , ppp.object_version_number
865: FROM per_all_assignments_f asg
866: , per_pay_bases ppb
867: , per_pay_proposals ppp
868: , ben_cwb_person_info per
869: WHERE per.group_per_in_ler_id = v_group_per_in_ler_id

Line 1146: from per_all_assignments_f asgn

1142: , asgn.ass_attribute27
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