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