DBA Data[Home] [Help]

APPS.PYUSDAR_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 169: per_periods_of_service pos,

165: --Bug 3331028-- Rule hint is used only for database version < 10.0
166: sqlstr := 'select '||l_db_version||' distinct pos.person_id
167: from pay_assignment_actions act,
168: per_assignments_f asg,
169: per_periods_of_service pos,
170: pay_payroll_actions pa2,
171: pay_payroll_actions pa1
172: where pa1.payroll_action_id = :payroll_action_id
173: and pa2.action_type in (''R'',''Q'')

Line 196: per_periods_of_service pos,

192: --Bug 3331028-- Rule hint is used only for database version < 10.0
193: sqlstr := 'select '||l_db_version||' distinct pos.person_id
194: from pay_assignment_actions act,
195: per_assignments_f asg,
196: per_periods_of_service pos,
197: pay_payroll_actions pa2,
198: pay_payroll_actions pa1
199: where pa1.payroll_action_id = :payroll_action_id
200: and pa2.consolidation_set_id =

Line 241: per_periods_of_service pos,

237: act.tax_unit_id
238: from pay_assignment_actions act,
239: per_all_assignments_f paf1,
240: per_all_assignments_f paf2,
241: per_periods_of_service pos,
242: pay_payroll_actions ppa_dar,
243: pay_payroll_actions ppa_mag_pmts,
244: pay_payrolls_f pay --Bug 3343621
245: where ( ppa_dar.payroll_action_id = pactid

Line 378: per_periods_of_service pos,

374: ppa_mag.effective_date
375: from pay_assignment_actions act,
376: per_all_assignments_f paf1,
377: per_all_assignments_f paf2,
378: per_periods_of_service pos,
379: pay_payroll_actions ppa_dar,
380: pay_payroll_actions ppa_mag,
381: pay_org_payment_methods_f popm --Bug 3009643
382: where ppa_dar.payroll_action_id = :pactid