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_INV_DED_FORMULAS dependencies on PER_ALL_ASSIGNMENTS_F

Line 3232: per_all_assignments_f paf,

3228: CURSOR c_get_res_state_code(p_element_entry_id in number) is
3229: select paf.assignment_id,
3230: pus.state_code
3231: from pay_element_entries_f pee,
3232: per_all_assignments_f paf,
3233: per_all_people_f ppf,
3234: per_addresses pa,
3235: pay_us_states pus
3236: where pee.element_entry_id = p_element_entry_id

Line 3246: per_all_assignments_f paf,

3242:
3243: CURSOR c_get_filing_status(p_assignment_id in number) is
3244: select filing_status_code
3245: from pay_us_emp_state_tax_rules_f pestr,
3246: per_all_assignments_f paf,
3247: hr_locations hl,
3248: pay_us_states pus
3249: where pestr.assignment_id = p_assignment_id
3250: and pestr.assignment_id = paf.assignment_id

Line 5163: per_all_assignments_f paaf

5159: CURSOR csr_get_filing_status_year is
5160: select ppei.pei_information1
5161: from per_people_extra_info ppei,
5162: pay_element_entries_f peef,
5163: per_all_assignments_f paaf
5164: where peef.element_entry_id = P_CTX_ORIGINAL_ENTRY_ID
5165: and peef.assignment_id = paaf.assignment_id
5166: and paaf.person_id = ppei.person_id
5167: and ppei.information_type = 'US_FED_LEVY_FIL_STATUS_YEAR';