DBA Data[Home] [Help]

APPS.PAY_IP_EXPIRY_SUPPORT dependencies on PAY_PAYROLL_ACTIONS

Line 64: ,pay_payroll_actions PACT

60: --
61: SELECT TP.end_date
62: INTO l_period_end_date
63: FROM per_time_periods TP
64: ,pay_payroll_actions PACT
65: WHERE PACT.payroll_action_id = p_owner_payroll_action_id
66: AND PACT.payroll_id = TP.payroll_id
67: AND p_owner_effective_date BETWEEN TP.start_date AND TP.end_date;
68: --

Line 152: FROM pay_payroll_actions pact

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

Line 239: FROM pay_payroll_actions pact

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