DBA Data[Home] [Help]

APPS.PAY_SE_EXPIRY_SUPPORT dependencies on PAY_PAYROLL_ACTIONS

Line 31: FROM pay_payroll_actions pact

27: --
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

Line 107: FROM pay_payroll_actions pact

103: --
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