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 671: per_all_assignments_f paf,

667:
668: sqlstr := 'select '||l_db_version||' paa.rowid
669: from hr_all_organization_units hou,
670: per_all_people_f ppf,
671: per_all_assignments_f paf,
672: pay_assignment_actions paa,
673: pay_payroll_actions ppa
674: where ppa.payroll_action_id = :pactid
675: and paa.payroll_action_id = ppa.payroll_action_id

Line 679: from per_all_assignments_f paf1

675: and paa.payroll_action_id = ppa.payroll_action_id
676: and paa.assignment_id = paf.assignment_id
677: and paf.effective_start_date =
678: (select max(paf1.effective_start_date)
679: from per_all_assignments_f paf1
680: where paf1.assignment_id = paf.assignment_id
681: and paf1.effective_start_date <= ppa.effective_date
682: and paf1.effective_end_date >= ppa.start_date
683: )

Line 729: per_all_assignments_f paf2,

725: pay_payroll_actions ppa_dar,
726: pay_payroll_actions ppa_mag,
727: pay_org_payment_methods_f popm,
728: pay_all_payrolls_f ppf,
729: per_all_assignments_f paf2,
730: hr_assignment_sets has,
731: hr_assignment_set_amendments hasa
732: where ppa_dar.payroll_action_id = pactid
733: and has.assignment_set_id = p_assignment_set_id

Line 891: per_all_assignments_f paf2,

887: ppa_mag.action_type
888: from pay_assignment_actions act,
889: pay_payroll_actions ppa_dar,
890: pay_payroll_actions ppa_mag,
891: per_all_assignments_f paf2,
892: pay_org_payment_methods_f popm, --Bug 3009643
893: pay_payrolls_f pay --Bug 3343621
894: where ppa_dar.payroll_action_id = :pactid
895: and ppa_mag.consolidation_set_id +0 = '|| nvl(ln_consolidation_set_id,0) ||'