APPS.PAY_CA_PAYRG_PKG dependencies on PAY_PAYMENT_INFORMATION_V

Line 19: to pay_payment_information_v. This is done

15: assignment actions with blank tax_unit_ids
16: also changed c_actions to break dependency
17: between payroll and consolidation set
18: 01-SEP-2004 mmukherj 115.18 Added action_status check when joining
19: to pay_payment_information_v. This is done
20: due to changes to view for bug 3826732.
21: 13-APR-2004 ssouresr 115.17 Corrected version 115.15 by changing the
22: cursors.
23: 13-APR-2004 ssouresr 115.15 The function action_creation is changed

Line 199: from pay_payment_information_v

195: cursor c_payment_info(cp_prepay_action_id number) is
196: select assignment_id,
197: tax_unit_id,
198: nvl(source_action_id,-999)
199: from pay_payment_information_v
200: where assignment_action_id = cp_prepay_action_id
201: and action_status = 'C'
202: order by 3,1,2;
203:

Line 294: from pay_payment_information_v ppi

290:
291: cursor c_other_asg_for_sepchk(cp_prepay_asg_act_id number
292: ,cp_assignment_id number) is
293: select distinct ppi.assignment_id
294: from pay_payment_information_v ppi
295: where ppi.assignment_action_id = cp_prepay_asg_act_id
296: and ppi.assignment_id <> cp_assignment_id
297: and ppi.action_status = 'C'
298: and ppi.source_action_id is null;