DBA Data[Home] [Help]

APPS.PAY_KR_WG_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 134: l_payroll_action_id pay_assignment_actions.payroll_action_id%TYPE;

130: l_correction_amount NUMBER := 0;
131: l_period_start_date DATE ;
132: l_period_end_date DATE ;
133: l_payout_date DATE ;
134: l_payroll_action_id pay_assignment_actions.payroll_action_id%TYPE;
135:
136: --Local variables introduced for Bug :4498363--
137: l_count_court_orders NUMBER := 0;
138: l_count_actual_attach NUMBER := 0;

Line 155: ,pay_assignment_actions ASSACTION

151: select TPERIOD.start_date
152: ,TPERIOD.end_date
153: ,PACTION.payroll_action_id
154: from pay_payroll_actions PACTION
155: ,pay_assignment_actions ASSACTION
156: ,per_time_periods TPERIOD
157: ,per_time_period_types TPTYPE
158: where ASSACTION.assignment_action_id = p_asg_action_id
159: and PACTION.payroll_action_id = ASSACTION.payroll_action_id

Line 337: ,pay_assignment_actions paa

333: --
334: CURSOR csr_prev_payout_bal_adj(p_element_type_id IN NUMBER) IS
335: SELECT fnd_date.canonical_to_date(prrv.result_value)
336: from pay_payroll_actions ppa
337: ,pay_assignment_actions paa
338: ,pay_run_results prr
339: ,pay_run_result_values prrv
340: ,pay_run_result_values prrv1
341: ,pay_input_values_f piv