APPS.PYCADAR_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 249: per_periods_of_service pos,

245: --Bug 3331023-- Rule hint is used only for database version < 10.0
246: sqlstr := 'select '||l_db_version||' distinct pos.person_id
247: from pay_assignment_actions act,
248: per_all_assignments_f asg,
249: per_periods_of_service pos,
250: pay_payroll_actions pa2,
251: pay_payroll_actions pa1,
252: pay_all_payrolls_f ppf
253: where pa1.payroll_action_id = :payroll_action_id

Line 277: per_periods_of_service pos,

273: --Bug 3331023-- Rule hint is used only for database version < 10.0
274: sqlstr := 'select '||l_db_version||' distinct pos.person_id
275: from pay_assignment_actions act,
276: per_all_assignments_f asg,
277: per_periods_of_service pos,
278: pay_payroll_actions pa2,
279: pay_payroll_actions pa1,
280: pay_all_payrolls_f ppf
281: where pa1.payroll_action_id = :payroll_action_id

Line 426: per_periods_of_service pos,

422: act.assignment_id,
423: act.tax_unit_id
424: from pay_assignment_actions act,
425: per_all_assignments_f paf1,
426: per_periods_of_service pos,
427: pay_payroll_actions ppa_dar,
428: pay_payroll_actions ppa_mag_pmts,
429: pay_all_payrolls_f ppf
430: where ( ppa_dar.payroll_action_id = pactid

Line 500: per_periods_of_service pos,

496: act.tax_unit_id
497: from pay_assignment_actions act,
498: per_all_assignments_f paf1,
499: per_all_assignments_f paf2,
500: per_periods_of_service pos,
501: pay_payroll_actions ppa_dar,
502: pay_payroll_actions ppa_mag,
503: pay_all_payrolls_f ppf,
504: hr_assignment_sets has,

Line 651: per_periods_of_service pos,

647: act.tax_unit_id
648: from pay_assignment_actions act,
649: per_all_assignments_f paf1,
650: per_all_assignments_f paf2,
651: per_periods_of_service pos,
652: pay_payroll_actions ppa_dar,
653: pay_payroll_actions ppa_mag,
654: pay_all_payrolls_f ppf
655: where ppa_dar.payroll_action_id = :pactid