APPS.PAY_US_ACTION_ARCH dependencies on PAY_PRE_PAYMENTS

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

5249: ** For Seperate Check we do the YTD balance calls with the Run
5250: ** Action ID. So, we do not need to get the max. action which is
5251: ** not seperate Check.
5252: ** Also, p_ppp_source_action_id is set to null as we want to get
5253: ** all records from pay_pre_payments where source_action_id is
5254: ** is null.
5255: ****************************************************************/
5256: ln_ytd_balcall_aaid := p_payment_action_id;
5257: if p_seperate_check_flag = 'N' and

Line 5675: ,pay_pre_payments ppp

5671: cursor c_get_prepay_aaid_for_sepchk( cp_asg_act_id number,
5672: cp_source_act_id number ) is
5673: select ppp.assignment_action_id
5674: from pay_assignment_actions paa
5675: ,pay_pre_payments ppp
5676: where ( paa.assignment_action_id = cp_asg_act_id OR
5677: paa.source_action_id = cp_asg_act_id )
5678: and ppp.assignment_action_id = paa.assignment_action_id
5679: and ppp.source_action_id = cp_source_act_id;