APPS.PAY_FI_EXPIRY_SUPPORT dependencies on HR_ORGANIZATION_INFORMATION

Line 118: ,hr_organization_information hoi

114: CURSOR get_period_type(p_payroll_action_id NUMBER, p_dimension_name VARCHAR2) IS
115: SELECT bd.period_type
116: ,pact.business_group_id
117: FROM pay_payroll_actions pact
118: ,hr_organization_information hoi
119: ,pay_balance_dimensions bd
120: WHERE pact.payroll_action_id = p_payroll_action_id
121: AND hoi.organization_id = pact.business_group_id
122: AND UPPER(hoi.org_information_context) = 'BUSINESS GROUP INFORMATION'

Line 253: ,hr_organization_information hoi

249: CURSOR get_period_type(p_payroll_action_id NUMBER, p_dimension_name VARCHAR2) IS
250: SELECT bd.period_type
251: ,pact.business_group_id
252: FROM pay_payroll_actions pact
253: ,hr_organization_information hoi
254: ,pay_balance_dimensions bd
255: WHERE pact.payroll_action_id = p_payroll_action_id
256: AND hoi.organization_id = pact.business_group_id
257: AND UPPER(hoi.org_information_context) = 'BUSINESS GROUP INFORMATION'

Line 366: ,hr_organization_information hoi

362: CURSOR csr_info(p_payroll_action_id NUMBER, p_dimension_name VARCHAR2) IS
363: SELECT bd.period_type
364: ,pact.business_group_id
365: FROM pay_payroll_actions pact
366: ,hr_organization_information hoi
367: ,pay_balance_dimensions bd
368: WHERE pact.payroll_action_id = p_payroll_action_id
369: AND hoi.organization_id = pact.business_group_id
370: AND UPPER(hoi.org_information_context) = 'BUSINESS GROUP INFORMATION'

Line 449: ,hr_organization_information hoi

445: CURSOR csr_info(p_payroll_action_id NUMBER, p_dimension_name VARCHAR2) IS
446: SELECT bd.period_type
447: ,pact.business_group_id
448: FROM pay_payroll_actions pact
449: ,hr_organization_information hoi
450: ,pay_balance_dimensions bd
451: WHERE pact.payroll_action_id = p_payroll_action_id
452: AND hoi.organization_id = pact.business_group_id
453: AND UPPER(hoi.org_information_context) = 'BUSINESS GROUP INFORMATION'