APPS.PAY_IP_PAYROLL_ARCH dependencies on PAY_PRE_PAYMENTS

Line 3779: ** all records from pay_pre_payments where source_action_id is

3775: ** For Seperate Check we do the YTD balance calls with the Run
3776: ** Action ID. So, we do not need to get the MAX. action which IS
3777: ** not seperate Check.
3778: ** Also, p_ppp_source_action_id is set to NULL as we want to get
3779: ** all records from pay_pre_payments where source_action_id is
3780: ** NULL.
3781: ****************************************************************/
3782: ln_ytd_balcall_aaid := p_payment_action_id;
3783: IF p_seperate_check_flag = 'N' AND

Line 4214: ,pay_pre_payments ppp

4210: CURSOR c_get_prepay_aaid_for_sepchk( cp_asg_act_id NUMBER,
4211: cp_source_act_id NUMBER ) IS
4212: SELECT ppp.assignment_action_id
4213: FROM pay_assignment_actions paa
4214: ,pay_pre_payments ppp
4215: WHERE ( paa.assignment_action_id = cp_asg_act_id OR
4216: paa.source_action_id = cp_asg_act_id )
4217: AND ppp.assignment_action_id = paa.assignment_action_id
4218: AND ppp.source_action_id = cp_source_act_id;