DBA Data[Home] [Help]

APPS.PAY_US_ACTION_ARCH dependencies on PAY_PAYMENT_INFORMATION_V

Line 5648: from pay_payment_information_v

5644: assignment_id
5645: ,tax_unit_id
5646: ,nvl(source_action_id,-999)
5647: ,assignment_action_id
5648: from pay_payment_information_v
5649: where assignment_action_id = cp_prepay_action_id
5650: order by 3,1,2;
5651:
5652: cursor c_run_aa_id(cp_pp_asg_act_id number

Line 5710: from pay_payment_information_v ppi

5706: from pay_action_information pai
5707: where pai.action_context_id = cp_xfr_action_id
5708: and pai.assignment_id = paf1.assignment_id)
5709: and not exists (select 1
5710: from pay_payment_information_v ppi
5711: where ppi.assignment_action_id = cp_prepay_action_id
5712: and ppi.assignment_id = paf1.assignment_id
5713: and ppi.source_action_id is null)
5714: order by paf1.assignment_id,