APPS.PYCADAR_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 224: per_periods_of_service pos,

220: --Bug 3331023-- Rule hint is used only for database version < 10.0
221: sqlstr := 'select '||l_db_version||' distinct pos.person_id
222: from pay_assignment_actions act,
223: per_all_assignments_f asg,
224: per_periods_of_service pos,
225: pay_payroll_actions pa2,
226: pay_payroll_actions pa1,
227: pay_all_payrolls_f ppf
228: where pa1.payroll_action_id = :payroll_action_id

Line 252: per_periods_of_service pos,

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

Line 389: per_periods_of_service pos,

385: act.assignment_id,
386: act.tax_unit_id
387: from pay_assignment_actions act,
388: per_all_assignments_f paf1,
389: per_periods_of_service pos,
390: pay_payroll_actions ppa_dar,
391: pay_payroll_actions ppa_mag_pmts,
392: pay_all_payrolls_f ppf
393: where ( ppa_dar.payroll_action_id = pactid

Line 463: per_periods_of_service pos,

459: act.tax_unit_id
460: from pay_assignment_actions act,
461: per_all_assignments_f paf1,
462: per_all_assignments_f paf2,
463: per_periods_of_service pos,
464: pay_payroll_actions ppa_dar,
465: pay_payroll_actions ppa_mag,
466: pay_all_payrolls_f ppf,
467: hr_assignment_sets has,

Line 614: per_periods_of_service pos,

610: act.tax_unit_id
611: from pay_assignment_actions act,
612: per_all_assignments_f paf1,
613: per_all_assignments_f paf2,
614: per_periods_of_service pos,
615: pay_payroll_actions ppa_dar,
616: pay_payroll_actions ppa_mag,
617: pay_all_payrolls_f ppf
618: where ppa_dar.payroll_action_id = :pactid