APPS.PAY_SE_BAL_UPLOAD dependencies on HR_ORGANIZATION_INFORMATION

Line 65: ,hr_organization_information hoi1

61: IS
62: SELECT SUBSTR (hoi4.org_information1, 4, 2)
63: ,SUBSTR (hoi4.org_information2, 4, 2)
64: FROM hr_organization_units o1
65: ,hr_organization_information hoi1
66: ,hr_organization_information hoi2
67: ,hr_organization_information hoi3
68: ,hr_organization_information hoi4
69: , (SELECT TRIM (scl.segment2) AS org_id

Line 66: ,hr_organization_information hoi2

62: SELECT SUBSTR (hoi4.org_information1, 4, 2)
63: ,SUBSTR (hoi4.org_information2, 4, 2)
64: FROM hr_organization_units o1
65: ,hr_organization_information hoi1
66: ,hr_organization_information hoi2
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

Line 67: ,hr_organization_information hoi3

63: ,SUBSTR (hoi4.org_information2, 4, 2)
64: FROM hr_organization_units o1
65: ,hr_organization_information hoi1
66: ,hr_organization_information hoi2
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

Line 68: ,hr_organization_information hoi4

64: FROM hr_organization_units o1
65: ,hr_organization_information hoi1
66: ,hr_organization_information hoi2
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

Line 99: ,hr_organization_information hoi1

95: IS
96:
97: SELECT HOI4.ORG_INFORMATION2
98: FROM hr_organization_units o1
99: ,hr_organization_information hoi1
100: ,hr_organization_information hoi2
101: ,hr_organization_information hoi3
102: ,hr_organization_information hoi4
103: , (SELECT TRIM (scl.segment2) AS org_id

Line 100: ,hr_organization_information hoi2

96:
97: SELECT HOI4.ORG_INFORMATION2
98: FROM hr_organization_units o1
99: ,hr_organization_information hoi1
100: ,hr_organization_information hoi2
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

Line 101: ,hr_organization_information hoi3

97: SELECT HOI4.ORG_INFORMATION2
98: FROM hr_organization_units o1
99: ,hr_organization_information hoi1
100: ,hr_organization_information hoi2
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

Line 102: ,hr_organization_information hoi4

98: FROM hr_organization_units o1
99: ,hr_organization_information hoi1
100: ,hr_organization_information hoi2
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