DBA Data[Home] [Help]

APPS.PAY_KR_WG_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 130: l_payroll_action_id pay_assignment_actions.payroll_action_id%TYPE;

126: l_correction_amount NUMBER := 0;
127: l_period_start_date DATE ;
128: l_period_end_date DATE ;
129: l_payout_date DATE ;
130: l_payroll_action_id pay_assignment_actions.payroll_action_id%TYPE;
131:
132: --Local variables introduced for Bug :4498363--
133: l_count_court_orders NUMBER := 0;
134: l_count_actual_attach NUMBER := 0;

Line 154: ,pay_assignment_actions ASSACTION

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

Line 343: ,pay_assignment_actions paa

339: --
340: CURSOR csr_prev_payout_bal_adj(p_element_type_id IN NUMBER) IS
341: SELECT fnd_date.canonical_to_date(prrv.result_value)
342: from pay_payroll_actions ppa
343: ,pay_assignment_actions paa
344: ,pay_run_results prr
345: ,pay_run_result_values prrv
346: ,pay_run_result_values prrv1
347: ,pay_input_values_f piv