DBA Data[Home] [Help]

APPS.PAY_SE_BAL_UPLOAD dependencies on HR_SOFT_CODING_KEYFLEX

Line 72: ,hr_soft_coding_keyflex scl

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
76: AND csr_v_upload_date BETWEEN asg.effective_start_date

Line 106: ,hr_soft_coding_keyflex scl

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
110: AND csr_v_upload_date BETWEEN asg.effective_start_date