DBA Data[Home] [Help]

APPS.PAY_CA_PAYROLL_ARCH dependencies on PAY_PAYMENT_INFORMATION_V

Line 137: Using view pay_payment_information_v

133: Modified cursor c_time_period.
134: 11-Apr-2003 vpandya 115.22 Changed archive_data:
135: create_child_actions_for_gre and
136: create_child_act_for_taxgrp.
137: Using view pay_payment_information_v
138: to archive assignments whether
139: it has zero and non zero payment.If
140: zero payment, then atleast earning
141: element has been processed.

Line 1120: from pay_payment_information_v

1116:
1117: cursor c_payment_info(cp_prepay_action_id number) is
1118: select distinct assignment_id
1119: ,nvl(source_action_id,-999)
1120: from pay_payment_information_v
1121: where assignment_action_id = cp_prepay_action_id
1122: order by 2,1;
1123:
1124: cursor c_get_pp_actid_of_multigre(cp_prepay_action_id number

Line 1456: from pay_payment_information_v

1452: cursor c_payment_info(cp_prepay_action_id number) is
1453: select assignment_id
1454: ,tax_unit_id
1455: ,nvl(source_action_id,-999)
1456: from pay_payment_information_v
1457: where assignment_action_id = cp_prepay_action_id
1458: order by 3,1,2;
1459:
1460: cursor c_get_pp_actid_of_multigre(cp_prepay_action_id number