DBA Data[Home] [Help]

APPS.PAY_US_ACTION_ARCH dependencies on PAY_PAYMENT_INFORMATION_V

Line 7708: from pay_payment_information_v

7704: assignment_id
7705: ,tax_unit_id
7706: ,nvl(source_action_id,-999)
7707: ,assignment_action_id
7708: from pay_payment_information_v
7709: where assignment_action_id = cp_prepay_action_id
7710: order by 3,1,2;
7711:
7712: cursor c_run_aa_id(cp_pp_asg_act_id number

Line 7771: from pay_payment_information_v ppi

7767: from pay_action_information pai
7768: where pai.action_context_id = cp_xfr_action_id
7769: and pai.assignment_id = paf1.assignment_id)
7770: and not exists (select 1
7771: from pay_payment_information_v ppi
7772: where ppi.assignment_action_id = cp_prepay_action_id
7773: and ppi.assignment_id = paf1.assignment_id
7774: and ppi.source_action_id is null)
7775: order by paf1.assignment_id,