APPS.PAY_SE_EXPIRY_SUPPORT dependencies on HR_ORGANIZATION_INFORMATION

Line 32: ,hr_organization_information hoi

28: CURSOR csr_info(p_payroll_action_id NUMBER, p_dimension_name VARCHAR2) IS
29: SELECT bd.period_type
30: ,pact.business_group_id
31: FROM pay_payroll_actions pact
32: ,hr_organization_information hoi
33: ,pay_balance_dimensions bd
34: WHERE pact.payroll_action_id = p_payroll_action_id
35: AND hoi.organization_id = pact.business_group_id
36: AND UPPER(hoi.org_information_context) = 'BUSINESS GROUP INFORMATION'

Line 108: ,hr_organization_information hoi

104: CURSOR csr_info(p_payroll_action_id NUMBER, p_dimension_name VARCHAR2) IS
105: SELECT bd.period_type
106: ,pact.business_group_id
107: FROM pay_payroll_actions pact
108: ,hr_organization_information hoi
109: ,pay_balance_dimensions bd
110: WHERE pact.payroll_action_id = p_payroll_action_id
111: AND hoi.organization_id = pact.business_group_id
112: AND UPPER(hoi.org_information_context) = 'BUSINESS GROUP INFORMATION'

Line 178: ,HR_ORGANIZATION_INFORMATION hoi1

174: WHERE assignment_action_id=p_assignment_action_id;
175: CURSOR csr_holiday_start IS
176: SELECT substr(hoi4.ORG_INFORMATION3,4,2)
177: FROM HR_ORGANIZATION_UNITS o1
178: ,HR_ORGANIZATION_INFORMATION hoi1
179: ,HR_ORGANIZATION_INFORMATION hoi2
180: ,HR_ORGANIZATION_INFORMATION hoi3
181: ,HR_ORGANIZATION_INFORMATION hoi4
182: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID

Line 179: ,HR_ORGANIZATION_INFORMATION hoi2

175: CURSOR csr_holiday_start IS
176: SELECT substr(hoi4.ORG_INFORMATION3,4,2)
177: FROM HR_ORGANIZATION_UNITS o1
178: ,HR_ORGANIZATION_INFORMATION hoi1
179: ,HR_ORGANIZATION_INFORMATION hoi2
180: ,HR_ORGANIZATION_INFORMATION hoi3
181: ,HR_ORGANIZATION_INFORMATION hoi4
182: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
183: FROM PER_ALL_ASSIGNMENTS_F ASG

Line 180: ,HR_ORGANIZATION_INFORMATION hoi3

176: SELECT substr(hoi4.ORG_INFORMATION3,4,2)
177: FROM HR_ORGANIZATION_UNITS o1
178: ,HR_ORGANIZATION_INFORMATION hoi1
179: ,HR_ORGANIZATION_INFORMATION hoi2
180: ,HR_ORGANIZATION_INFORMATION hoi3
181: ,HR_ORGANIZATION_INFORMATION hoi4
182: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
183: FROM PER_ALL_ASSIGNMENTS_F ASG
184: ,HR_SOFT_CODING_KEYFLEX SCL

Line 181: ,HR_ORGANIZATION_INFORMATION hoi4

177: FROM HR_ORGANIZATION_UNITS o1
178: ,HR_ORGANIZATION_INFORMATION hoi1
179: ,HR_ORGANIZATION_INFORMATION hoi2
180: ,HR_ORGANIZATION_INFORMATION hoi3
181: ,HR_ORGANIZATION_INFORMATION hoi4
182: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
183: FROM PER_ALL_ASSIGNMENTS_F ASG
184: ,HR_SOFT_CODING_KEYFLEX SCL
185: WHERE ASG.ASSIGNMENT_ID = l_assignment_id