DBA Data[Home] [Help]

APPS.PAY_IP_EXPIRY_SUPPORT dependencies on HR_ORGANIZATION_INFORMATION

Line 153: ,hr_organization_information hoi

149: CURSOR csr_info(p_payroll_action_id NUMBER, p_dimension_name VARCHAR2) IS
150: SELECT bd.period_type
151: ,pact.business_group_id
152: FROM pay_payroll_actions pact
153: ,hr_organization_information hoi
154: ,pay_balance_dimensions bd
155: WHERE pact.payroll_action_id = p_payroll_action_id
156: AND hoi.organization_id = pact.business_group_id
157: AND UPPER(hoi.org_information_context) = 'BUSINESS GROUP INFORMATION'

Line 240: ,hr_organization_information hoi

236: CURSOR csr_info(p_payroll_action_id NUMBER, p_dimension_name VARCHAR2) IS
237: SELECT bd.period_type
238: ,pact.business_group_id
239: FROM pay_payroll_actions pact
240: ,hr_organization_information hoi
241: ,pay_balance_dimensions bd
242: WHERE pact.payroll_action_id = p_payroll_action_id
243: AND hoi.organization_id = pact.business_group_id
244: AND UPPER(hoi.org_information_context) = 'BUSINESS GROUP INFORMATION'