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 192: ,HR_ORGANIZATION_INFORMATION hoi1

188: CURSOR csr_holiday_start (l_business_group_id number,
189: l_assignment_id number)IS
190: SELECT substr(hoi4.ORG_INFORMATION3,4,2)
191: FROM HR_ORGANIZATION_UNITS o1
192: ,HR_ORGANIZATION_INFORMATION hoi1
193: ,HR_ORGANIZATION_INFORMATION hoi2
194: ,HR_ORGANIZATION_INFORMATION hoi3
195: ,HR_ORGANIZATION_INFORMATION hoi4
196: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID

Line 193: ,HR_ORGANIZATION_INFORMATION hoi2

189: l_assignment_id number)IS
190: SELECT substr(hoi4.ORG_INFORMATION3,4,2)
191: FROM HR_ORGANIZATION_UNITS o1
192: ,HR_ORGANIZATION_INFORMATION hoi1
193: ,HR_ORGANIZATION_INFORMATION hoi2
194: ,HR_ORGANIZATION_INFORMATION hoi3
195: ,HR_ORGANIZATION_INFORMATION hoi4
196: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
197: FROM PER_ALL_ASSIGNMENTS_F ASG

Line 194: ,HR_ORGANIZATION_INFORMATION hoi3

190: SELECT substr(hoi4.ORG_INFORMATION3,4,2)
191: FROM HR_ORGANIZATION_UNITS o1
192: ,HR_ORGANIZATION_INFORMATION hoi1
193: ,HR_ORGANIZATION_INFORMATION hoi2
194: ,HR_ORGANIZATION_INFORMATION hoi3
195: ,HR_ORGANIZATION_INFORMATION hoi4
196: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
197: FROM PER_ALL_ASSIGNMENTS_F ASG
198: ,HR_SOFT_CODING_KEYFLEX SCL

Line 195: ,HR_ORGANIZATION_INFORMATION hoi4

191: FROM HR_ORGANIZATION_UNITS o1
192: ,HR_ORGANIZATION_INFORMATION hoi1
193: ,HR_ORGANIZATION_INFORMATION hoi2
194: ,HR_ORGANIZATION_INFORMATION hoi3
195: ,HR_ORGANIZATION_INFORMATION hoi4
196: ,( SELECT TRIM(SCL.SEGMENT2) AS ORG_ID
197: FROM PER_ALL_ASSIGNMENTS_F ASG
198: ,HR_SOFT_CODING_KEYFLEX SCL
199: WHERE ASG.ASSIGNMENT_ID = l_assignment_id