DBA Data[Home] [Help]

APPS.PYUSDAR_PKG dependencies on PER_ASSIGNMENTS_F

Line 168: per_assignments_f asg,

164: if l_payroll_id is not null then
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

Line 195: per_assignments_f asg,

191: --
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

Line 601: from per_assignments_f paf,

597: select
598: paa_xfr.assignment_action_id,
599: paa_xfr.assignment_id,
600: paa_xfr.tax_unit_id
601: from per_assignments_f paf,
602: pay_payroll_actions ppa_dar,
603: pay_payroll_actions ppa_run,
604: pay_assignment_actions paa_run,
605: pay_action_interlocks pai_pre,

Line 725: from per_assignments_f paf,

721: select
722: paa_xfr.assignment_action_id,
723: paa_xfr.assignment_id,
724: paa_xfr.tax_unit_id
725: from per_assignments_f paf,
726: pay_payroll_actions ppa_dar,
727: pay_payroll_actions ppa_run,
728: pay_payroll_actions ppa_pre,
729: pay_action_interlocks pai_pre,