APPS.PAY_KW_CHEQUE_REPORT dependencies on PAY_PAYROLL_ACTIONS

Line 52: FROM pay_payroll_actions

48:
49: /* Cursor to fetch date_earned for the payroll action */
50: CURSOR csr_get_DE (l_pact_id number) IS
51: SELECT nvl(date_earned,effective_date)
52: FROM pay_payroll_actions
53: WHERE payroll_action_id = l_pact_id;
54:
55: /* Cursor to fetch payroll_name for the payroll action */
56: CURSOR csr_get_PY (l_pact_id number) IS

Line 58: FROM pay_all_payrolls_f pap, pay_payroll_actions ppa

54:
55: /* Cursor to fetch payroll_name for the payroll action */
56: CURSOR csr_get_PY (l_pact_id number) IS
57: SELECT payroll_name
58: FROM pay_all_payrolls_f pap, pay_payroll_actions ppa
59: WHERE ppa.payroll_action_id = l_pact_id
60: AND ppa.payroll_id = pap.payroll_id;
61:
62:

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

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

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

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

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

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

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

134:
135: /*
136: CURSOR csr_get_assact_det_PD (l_pact_id number) IS
137: select paa.assignment_action_id , paa.assignment_id
138: from pay_assignment_actions paa , pay_payroll_actions ppa , pay_pre_payments ppp , pay_assignment_actions paa1
139: where paa.payroll_action_id = p_pact_id
140: and paa.action_status = 'C'
141: and not exists ( select 1
142: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck

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

138: from pay_assignment_actions paa , pay_payroll_actions ppa , pay_pre_payments ppp , pay_assignment_actions paa1
139: where paa.payroll_action_id = p_pact_id
140: and paa.action_status = 'C'
141: and not exists ( select 1
142: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck
143: where lck.locked_action_id = paa.assignment_action_id
144: and lck.locking_action_id = paa1.assignment_action_id
145: and ppa1.payroll_action_id = paa1.payroll_action_id
146: and ppa1.action_type = 'D'

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

156: */
157:
158: CURSOR csr_get_assact_det_PD (l_pact_id number,l_date date) IS
159: select paa.assignment_action_id , paa.assignment_id
160: from pay_assignment_actions paa , pay_payroll_actions ppa , pay_pre_payments ppp , pay_assignment_actions paa1,
161: per_all_people_f ppf, per_all_assignments_f paf
162: where paa.payroll_action_id = p_pact_id
163: and paa.action_status IN ('C','S') -- 10375683
164: and not exists ( select 1

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

161: per_all_people_f ppf, per_all_assignments_f paf
162: where paa.payroll_action_id = p_pact_id
163: and paa.action_status IN ('C','S') -- 10375683
164: and not exists ( select 1
165: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck
166: where lck.locked_action_id = paa.assignment_action_id
167: and lck.locking_action_id = paa1.assignment_action_id
168: and ppa1.payroll_action_id = paa1.payroll_action_id
169: and ppa1.action_type = 'D'

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

226:
227: /* Cursor for fetching the payment date of the pre payment for cheques */
228: CURSOR csr_pay_date (l_assact_id number) IS
229: select nvl(ppa.date_earned,ppa.effective_date)
230: from pay_payroll_actions ppa, pay_assignment_actions paa, pay_pre_payments ppp, pay_assignment_actions paa1
231: where paa.assignment_action_id = l_assact_id
232: and paa.action_status IN ('C','S') --10375683
233: and paa.pre_payment_id = ppp.pre_payment_id
234: and ppp.assignment_action_id = paa1.assignment_action_id