45: from pay_action_interlocks ai
46: where ai.locking_action_id = paa.assignment_action_id )
47: and exists
48: (select 1 from pay_assignment_actions paa2,
49: pay_payroll_actions ppa2
50: where paa2.assignment_id = paa.assignment_id
51: and paa2.payroll_action_id = ppa2.payroll_action_id
52: and ppa2.action_type = 'Z');
53:
61: cursor c_get_prepay_id(p_assignment_action_id in number) is
62: SELECT paa.assignment_action_id,ppp.pre_payment_id
63: FROM pay_action_interlocks pai
64: ,pay_assignment_actions paa
65: ,pay_payroll_actions ppa
66: ,pay_pre_payments ppp
67: WHERE pai.locked_action_id = paa.assignment_action_id
68: AND paa.payroll_action_id = ppa.payroll_action_id
69: AND ppa.action_type in ('P','U')