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.PAY_US_DEPOSIT_ADVICE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 681: per_all_assignments_f paf,

677:
678: sqlstr := 'select '||l_db_version||' paa.rowid
679: from hr_all_organization_units hou,
680: per_all_people_f ppf,
681: per_all_assignments_f paf,
682: pay_assignment_actions paa,
683: pay_payroll_actions ppa
684: where ppa.payroll_action_id = :pactid
685: and paa.payroll_action_id = ppa.payroll_action_id

Line 689: from per_all_assignments_f paf1

685: and paa.payroll_action_id = ppa.payroll_action_id
686: and paa.assignment_id = paf.assignment_id
687: and paf.effective_start_date =
688: (select max(paf1.effective_start_date)
689: from per_all_assignments_f paf1
690: where paf1.assignment_id = paf.assignment_id
691: and paf1.effective_start_date <= ppa.effective_date
692: and paf1.effective_end_date >= ppa.start_date
693: )

Line 739: per_all_assignments_f paf2,

735: pay_payroll_actions ppa_dar,
736: pay_payroll_actions ppa_mag,
737: pay_org_payment_methods_f popm,
738: pay_all_payrolls_f ppf,
739: per_all_assignments_f paf2,
740: hr_assignment_sets has,
741: hr_assignment_set_amendments hasa
742: where ppa_dar.payroll_action_id = pactid
743: and has.assignment_set_id = p_assignment_set_id

Line 901: per_all_assignments_f paf2,

897: ppa_mag.action_type
898: from pay_assignment_actions act,
899: pay_payroll_actions ppa_dar,
900: pay_payroll_actions ppa_mag,
901: per_all_assignments_f paf2,
902: pay_org_payment_methods_f popm, --Bug 3009643
903: pay_payrolls_f pay --Bug 3343621
904: where ppa_dar.payroll_action_id = :pactid
905: and ppa_mag.consolidation_set_id +0 = '|| nvl(ln_consolidation_set_id,0) ||'