eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PYCADAR_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 207: per_all_assignments_f paf,

203: sqlstr := 'select
204: distinct paf.person_id
205: from
206: hr_assignment_set_amendments hasa,
207: per_all_assignments_f paf,
208: pay_payroll_actions ppa
209: where
210: ppa.payroll_action_id = :PACTID and
211: hasa.assignment_set_id = ' || to_char(l_asg_set_id) ||

Line 223: per_all_assignments_f asg,

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

Line 251: per_all_assignments_f asg,

247: else
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

Line 388: per_all_assignments_f paf1,

384: select act.assignment_action_id,
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

Line 461: per_all_assignments_f paf1,

457: select act.assignment_action_id,
458: act.assignment_id,
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,

Line 462: per_all_assignments_f paf2,

458: act.assignment_id,
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,

Line 612: per_all_assignments_f paf1,

608: l_actions := 'select '||l_db_version||' distinct act.assignment_action_id,
609: act.assignment_id,
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,

Line 613: per_all_assignments_f paf2,

609: act.assignment_id,
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