APPS.PAY_AE_PAYROLL_REGISTER dependencies on PAY_ALL_PAYROLLS_F

Line 142: from pay_all_payrolls_f

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

Line 148: from pay_all_payrolls_f

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

Line 165: ,pay_all_payrolls_f ppf

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

Line 188: ,pay_all_payrolls_f ppf

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

Line 221: ,pay_all_payrolls_f ppf

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

Line 243: ,pay_all_payrolls_f ppf

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

Line 265: ,pay_all_payrolls_f ppf

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

Line 298: ,pay_all_payrolls_f ppf

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

Line 345: ,pay_all_payrolls_f ppf

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