APPS.PAY_KW_PAYROLL_REGISTER dependencies on PAY_ALL_PAYROLLS_F

Line 144: from pay_all_payrolls_f

140: where ORGANIZATION_ID = l_org_id;
141: /* SELECTS BUSINESS GROUP ID FROM THE PAYROLL SPECIFIED */
142: CURSOR csr_get_bg_id_pay (l_payroll_id number , l_effective_date date) IS
143: select business_group_id
144: from pay_all_payrolls_f
145: where payroll_id = l_payroll_id
146: AND trunc(l_effective_date,'MM') between trunc(effective_start_date,'MM') and effective_end_date;
147: /* SELECTS PAYROLL NAME FOR HEADER */
148: CURSOR csr_get_payroll_name(l_pyrl_id number , l_eff_date date) IS

Line 150: from pay_all_payrolls_f

146: AND trunc(l_effective_date,'MM') between trunc(effective_start_date,'MM') and effective_end_date;
147: /* SELECTS PAYROLL NAME FOR HEADER */
148: CURSOR csr_get_payroll_name(l_pyrl_id number , l_eff_date date) IS
149: select payroll_name
150: from pay_all_payrolls_f
151: where PAYROLL_ID = l_pyrl_id
152: and l_eff_date between effective_start_date and effective_end_date;
153: /* SELECTS ORGANIZATION NAME FOR HEADER */
154: CURSOR csr_get_organization_name (l_org_id number) IS

Line 167: ,pay_all_payrolls_f ppf

163: ,pay_action_information pai_emp
164: ,pay_assignment_actions paa1
165: ,pay_action_interlocks lck
166: ,pay_payroll_actions ppa1
167: ,pay_all_payrolls_f ppf
168: WHERE ptp.payroll_id = l_payroll_id
169: AND ptp.time_period_id = pai_emp.action_information16
170: AND pai_emp.action_context_type = 'AAP'
171: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'

Line 190: ,pay_all_payrolls_f ppf

186: ,pay_action_information pai_emp
187: ,pay_assignment_actions paa1
188: ,pay_action_interlocks lck
189: ,pay_payroll_actions ppa1
190: ,pay_all_payrolls_f ppf
191: WHERE ptp.time_period_id = pai_emp.action_information16
192: AND pai_emp.action_context_type = 'AAP'
193: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'
194: AND lck.locking_action_id = pai_emp.action_context_id

Line 223: ,pay_all_payrolls_f ppf

219: ,pay_action_information pai_emp
220: ,pay_assignment_actions paa1
221: ,pay_action_interlocks lck
222: ,pay_payroll_actions ppa1
223: ,pay_all_payrolls_f ppf
224: WHERE ptp.time_period_id = pai_emp.action_information16
225: AND pai_emp.action_context_type = 'AAP'
226: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'
227: AND lck.locking_action_id = pai_emp.action_context_id

Line 245: ,pay_all_payrolls_f ppf

241: ,pay_action_information pai_emp
242: ,pay_assignment_actions paa1
243: ,pay_action_interlocks lck
244: ,pay_payroll_actions ppa1
245: ,pay_all_payrolls_f ppf
246: WHERE ptp.time_period_id = pai_emp.action_information16
247: AND pai_emp.action_context_type = 'AAP'
248: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'
249: AND lck.locking_action_id = pai_emp.action_context_id

Line 267: ,pay_all_payrolls_f ppf

263: ,pay_action_information pai_emp
264: ,pay_assignment_actions paa1
265: ,pay_action_interlocks lck
266: ,pay_payroll_actions ppa1
267: ,pay_all_payrolls_f ppf
268: WHERE ptp.time_period_id = pai_emp.action_information16
269: AND pai_emp.action_context_type = 'AAP'
270: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'
271: AND lck.locking_action_id = pai_emp.action_context_id

Line 300: ,pay_all_payrolls_f ppf

296: ,pay_action_information pai_emp
297: ,pay_assignment_actions paa1
298: ,pay_action_interlocks lck
299: ,pay_payroll_actions ppa1
300: ,pay_all_payrolls_f ppf
301: WHERE ptp.time_period_id = pai_emp.action_information16
302: AND pai_emp.action_context_type = 'AAP'
303: AND pai_emp.action_information_category = 'EMPLOYEE DETAILS'
304: AND lck.locking_action_id = pai_emp.action_context_id

Line 347: ,pay_all_payrolls_f ppf

343: ,pay_action_information pai_emp1
344: ,pay_assignment_actions paa1
345: ,pay_action_interlocks lck
346: ,pay_payroll_actions ppa1
347: ,pay_all_payrolls_f ppf
348: WHERE ptp.payroll_id = l_payroll_id
349: AND ptp.time_period_id = pai_emp.action_information16
350: AND pai_emp.action_context_id = pai_emp1.action_context_id
351: AND pai_emp.action_context_type = 'AAP'