APPS.PAY_SA_CHEQUE_REPORT dependencies on PAY_ASSIGNMENT_ACTIONS

Line 69: from pay_assignment_actions paa

65: /*
66:
67: CURSOR csr_get_assact_det (l_pact_id number) IS
68: select paa.assignment_action_id , paa.assignment_id
69: from pay_assignment_actions paa
70: where paa.payroll_action_id = p_pact_id
71: and paa.action_status = 'C'
72: and not exists ( select 1
73: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck

Line 73: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck

69: from pay_assignment_actions paa
70: where paa.payroll_action_id = p_pact_id
71: and paa.action_status = 'C'
72: and not exists ( select 1
73: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck
74: where lck.locked_action_id = paa.assignment_action_id
75: and lck.locking_action_id = paa1.assignment_action_id
76: and ppa1.payroll_action_id = paa1.payroll_action_id
77: and ppa1.action_type = 'D'

Line 87: from pay_assignment_actions paa , per_all_assignments_f paf, hr_all_organization_units hou, per_all_people_f ppf

83: /*** ORDER BY ORG ***/
84: /* Cursor for fetching assignment action id and assignment id for current payroll action id order by org name */
85: CURSOR csr_get_assact_det_ORG (l_pact_id number , l_date date) IS
86: select paa.assignment_action_id , paa.assignment_id
87: from pay_assignment_actions paa , per_all_assignments_f paf, hr_all_organization_units hou, per_all_people_f ppf
88: where paa.payroll_action_id = p_pact_id
89: and paa.action_status = 'C'
90: and not exists ( select 1
91: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck

Line 91: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck

87: from pay_assignment_actions paa , per_all_assignments_f paf, hr_all_organization_units hou, per_all_people_f ppf
88: where paa.payroll_action_id = p_pact_id
89: and paa.action_status = 'C'
90: and not exists ( select 1
91: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck
92: where lck.locked_action_id = paa.assignment_action_id
93: and lck.locking_action_id = paa1.assignment_action_id
94: and ppa1.payroll_action_id = paa1.payroll_action_id
95: and ppa1.action_type = 'D'

Line 110: from pay_assignment_actions paa , per_all_assignments_f paf, per_all_people_f ppf

106: /*** ORDER BY EMPNO ***/
107: /* Cursor for fetching assignment action id and assignment id for current payroll action id order by emp no*/
108: CURSOR csr_get_assact_det_EMPNO (l_pact_id number , l_date date) IS
109: select paa.assignment_action_id , paa.assignment_id
110: from pay_assignment_actions paa , per_all_assignments_f paf, per_all_people_f ppf
111: where paa.payroll_action_id = p_pact_id
112: and paa.action_status = 'C'
113: and not exists ( select 1
114: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck

Line 114: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck

110: from pay_assignment_actions paa , per_all_assignments_f paf, per_all_people_f ppf
111: where paa.payroll_action_id = p_pact_id
112: and paa.action_status = 'C'
113: and not exists ( select 1
114: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck
115: where lck.locked_action_id = paa.assignment_action_id
116: and lck.locking_action_id = paa1.assignment_action_id
117: and ppa1.payroll_action_id = paa1.payroll_action_id
118: and ppa1.action_type = 'D'

Line 131: from pay_assignment_actions paa , pay_payroll_actions ppa , pay_pre_payments ppp , pay_assignment_actions paa1,

127: /*** ORDER BY PAYDATE ***/
128: /* Cursor for fetching assignment action id and assignment id for current payroll action id order by payment date*/
129: CURSOR csr_get_assact_det_PD (l_pact_id number,l_date date) IS
130: select paa.assignment_action_id , paa.assignment_id
131: from pay_assignment_actions paa , pay_payroll_actions ppa , pay_pre_payments ppp , pay_assignment_actions paa1,
132: per_all_people_f ppf, per_all_assignments_f paf
133: where paa.payroll_action_id = p_pact_id
134: and paa.action_status IN ('C','S')
135: and not exists ( select 1

Line 136: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck

132: per_all_people_f ppf, per_all_assignments_f paf
133: where paa.payroll_action_id = p_pact_id
134: and paa.action_status IN ('C','S')
135: and not exists ( select 1
136: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck
137: where lck.locked_action_id = paa.assignment_action_id
138: and lck.locking_action_id = paa1.assignment_action_id
139: and ppa1.payroll_action_id = paa1.payroll_action_id
140: and ppa1.action_type = 'D'

Line 173: pay_payment_types pt,pay_assignment_actions paa1

169: WHERE pv2.business_group_id+0 = p_business_group_id
170: AND pv2.assignment_action_id = l_assact_id
171: AND pv2.pre_payment_id in (select ppp.pre_payment_id
172: from pay_pre_payments ppp,pay_action_interlocks lck , pay_org_payment_methods_f org ,
173: pay_payment_types pt,pay_assignment_actions paa1
174: where lck.locking_action_id = l_assact_id
175: and lck.locked_action_id = ppp.assignment_action_id
176: and paa1.assignment_action_id = lck.locking_action_id
177: and paa1.pre_payment_id = ppp.pre_payment_id

Line 201: from pay_payroll_actions ppa, pay_assignment_actions paa, pay_pre_payments ppp, pay_assignment_actions paa1

197:
198: /* Cursor for fetching the payment date of the pre payment for cheques */
199: CURSOR csr_pay_date (l_assact_id number) IS
200: select nvl(ppa.date_earned,ppa.effective_date)
201: from pay_payroll_actions ppa, pay_assignment_actions paa, pay_pre_payments ppp, pay_assignment_actions paa1
202: where paa.assignment_action_id = l_assact_id
203: and paa.action_status IN ('C','S')
204: and paa.pre_payment_id = ppp.pre_payment_id
205: and ppp.assignment_action_id = paa1.assignment_action_id