APPS.PAY_CA_PAYRG_PKG dependencies on PAY_PAYMENT_INFORMATION_V

Line 24: to pay_payment_information_v. This is done

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

Line 204: from pay_payment_information_v

200: cursor c_payment_info(cp_prepay_action_id number) is
201: select assignment_id,
202: tax_unit_id,
203: nvl(source_action_id,-999)
204: from pay_payment_information_v
205: where assignment_action_id = cp_prepay_action_id
206: and action_status = 'C'
207: order by 3,1,2;
208:

Line 299: from pay_payment_information_v ppi

295:
296: cursor c_other_asg_for_sepchk(cp_prepay_asg_act_id number
297: ,cp_assignment_id number) is
298: select distinct ppi.assignment_id
299: from pay_payment_information_v ppi
300: where ppi.assignment_action_id = cp_prepay_asg_act_id
301: and ppi.assignment_id <> cp_assignment_id
302: and ppi.action_status = 'C'
303: and ppi.source_action_id is null;