[Home] [Help]
3194: ** #7 p_curr_pymt_eff_date : The effective date of prepayments.
3195: ** #8 p_tax_unit_id : tax_unit_id from pay_assignment_actions
3196: ** #9 p_time_period_id : Time Period Id of the Run.
3197: ** #10 p_ppp_source_action_id : This is the source_action_id of
3198: ** pay_pre_payments for the 'P','U' action.
3199: ** #11 p_ytd_balcall_aaid : This is the assignment action id to call
3200: ** balances other than ASG_PAYMENTS for Employee
3201: ** other information.
3202: **********************************************************************/
3603: ** For Seperate Check we do the YTD balance calls with the Run
3604: ** Action ID. So, we do not need to get the MAX. action which IS
3605: ** not seperate Check.
3606: ** Also, p_ppp_source_action_id is set to NULL as we want to get
3607: ** all records from pay_pre_payments where source_action_id is
3608: ** NULL.
3609: ****************************************************************/
3610: ln_ytd_balcall_aaid := p_payment_action_id;
3611: IF p_seperate_check_flag = 'N' AND
4827: CURSOR c_get_prepay_aaid_for_sepchk( cp_asg_act_id NUMBER,
4828: cp_source_act_id NUMBER ) IS
4829: SELECT ppp.assignment_action_id
4830: FROM pay_assignment_actions paa
4831: ,pay_pre_payments ppp
4832: WHERE ( paa.assignment_action_id = cp_asg_act_id OR
4833: paa.source_action_id = cp_asg_act_id )
4834: AND ppp.assignment_action_id = paa.assignment_action_id
4835: AND ppp.source_action_id = cp_source_act_id;