DBA Data[Home] [Help]

APPS.PAY_SE_BAL_UPLOAD dependencies on PER_ALL_ASSIGNMENTS_F

Line 71: FROM per_all_assignments_f asg

67: ,hr_organization_information hoi3
68: ,hr_organization_information hoi4
69: , (SELECT TRIM (scl.segment2) AS org_id
70: ,business_group_id AS bus_id
71: FROM per_all_assignments_f asg
72: ,hr_soft_coding_keyflex scl
73: WHERE asg.assignment_id = csr_v_assignment_id
74: AND asg.soft_coding_keyflex_id =
75: scl.soft_coding_keyflex_id

Line 105: FROM per_all_assignments_f asg

101: ,hr_organization_information hoi3
102: ,hr_organization_information hoi4
103: , (SELECT TRIM (scl.segment2) AS org_id
104: ,business_group_id AS bus_id
105: FROM per_all_assignments_f asg
106: ,hr_soft_coding_keyflex scl
107: WHERE asg.assignment_id = csr_v_assignment_id
108: AND asg.soft_coding_keyflex_id =
109: scl.soft_coding_keyflex_id