APPS.PAY_SA_PAYMENT_STATUS_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 41: from pay_assignment_actions paa

37: return varchar2 is
38:
39: cursor c_purge_run(p_assignment_action_id in number) is
40: select 1
41: from pay_assignment_actions paa
42: where paa.assignment_action_id = p_assignment_action_id
43: and not exists
44: (select 1
45: from pay_action_interlocks ai

Line 48: (select 1 from pay_assignment_actions paa2,

44: (select 1
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');

Line 64: ,pay_assignment_actions paa

60:
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

Line 101: l_status := pay_assignment_actions_pkg.get_payment_status(l_pre_pay_asg_id,l_pre_pay_id);

97: open c_get_prepay_id(p_assignment_action_id);
98: fetch c_get_prepay_id into l_pre_pay_asg_id,l_pre_pay_id;
99: /* Fetch the Pre-payment assignmnt action id, pre payment id */
100: if c_get_prepay_id%found then
101: l_status := pay_assignment_actions_pkg.get_payment_status(l_pre_pay_asg_id,l_pre_pay_id);
102: return l_status;
103: end if;
104: close c_get_prepay_id;
105: end if;