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.JE_ES_WHTAX dependencies on PER_ALL_PEOPLE_F

Line 701: FROM PER_ALL_PEOPLE_F WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf

697: ap_tax_codes_all atc,
698: ap_awt_tax_rates_all awt,
699: (SELECT distinct person_id
700: ,national_identifier
701: FROM PER_ALL_PEOPLE_F WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf
702: WHERE v.vendor_id = vs.vendor_id
703: AND nvl(v.employee_id,-99) = papf.person_id (+)
704: -- bug 8551359 - start
705: --AND vs.tax_reporting_site_flag = 'Y'

Line 800: FROM PER_ALL_PEOPLE_F WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf

796: ap_invoice_lines_all line,
797: ap_invoice_distributions_all dist,
798: (SELECT distinct person_id
799: ,national_identifier
800: FROM PER_ALL_PEOPLE_F WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf
801: WHERE v.vendor_id = vs.vendor_id
802: AND nvl(v.employee_id,-99) = papf.person_id (+)
803: -- bug 8551359 - start
804: --AND vs.tax_reporting_site_flag = 'Y'

Line 951: FROM PER_ALL_PEOPLE_F WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf

947: ap_invoice_lines_all line,
948: ap_invoice_distributions_all dist,
949: (SELECT distinct person_id
950: ,national_identifier
951: FROM PER_ALL_PEOPLE_F WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf
952: WHERE vs.country = fl.lookup_code(+)
953: AND 'JEES_EURO_COUNTRY_CODES' = fl.lookup_type
954: ---AND v.vendor_id = nvl(p_vendor_id,v.vendor_id)
955: AND (( p_vendor_id is null and v.vendor_id = v.vendor_id) or (v.vendor_id = p_vendor_id))

Line 1130: FROM PER_ALL_PEOPLE_F WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf

1126: ap_invoice_lines_all line,
1127: ap_invoice_distributions_all dist,
1128: (SELECT distinct person_id
1129: ,national_identifier
1130: FROM PER_ALL_PEOPLE_F WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf
1131: WHERE vs.country = fl.lookup_code(+)
1132: AND 'JEES_EURO_COUNTRY_CODES' = fl.lookup_type
1133: ---AND v.vendor_id = nvl(p_vendor_id,v.vendor_id)
1134: AND (( p_vendor_id is null and v.vendor_id = v.vendor_id) or (v.vendor_id = p_vendor_id))

Line 1322: FROM PER_ALL_PEOPLE_F WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf

1318: ap_invoice_lines_all line,
1319: ap_invoice_distributions_all dist,
1320: (SELECT distinct person_id
1321: ,national_identifier
1322: FROM PER_ALL_PEOPLE_F WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf
1323: WHERE vs.country = fl.lookup_code(+)
1324: AND 'JEES_EURO_COUNTRY_CODES' = fl.lookup_type
1325: AND (( p_vendor_id is null and v.vendor_id = v.vendor_id) or (v.vendor_id = p_vendor_id))
1326: AND nvl(v.employee_id,-99) = papf.person_id (+)

Line 1498: FROM PER_ALL_PEOPLE_F WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf

1494: ap_invoice_lines_all line,
1495: ap_invoice_distributions_all dist,
1496: (SELECT distinct person_id
1497: ,national_identifier
1498: FROM PER_ALL_PEOPLE_F WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf
1499: WHERE vs.country = fl.lookup_code(+)
1500: AND 'JEES_EURO_COUNTRY_CODES' = fl.lookup_type
1501: AND (( p_vendor_id is null and v.vendor_id = v.vendor_id) or (v.vendor_id = p_vendor_id))
1502: AND nvl(v.employee_id,-99) = papf.person_id (+)

Line 1688: FROM PER_ALL_PEOPLE_F WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf

1684: ap_invoice_lines_all line,
1685: ap_invoice_distributions_all dist,
1686: (SELECT distinct person_id
1687: ,national_identifier
1688: FROM PER_ALL_PEOPLE_F WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf
1689: WHERE vs.country = fl.lookup_code(+)
1690: AND 'JEES_EURO_COUNTRY_CODES' = fl.lookup_type
1691: AND (( p_vendor_id is null and v.vendor_id = v.vendor_id) or (v.vendor_id = p_vendor_id))
1692: AND nvl(v.employee_id,-99) = papf.person_id (+)

Line 1862: FROM PER_ALL_PEOPLE_F WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf

1858: ap_invoice_lines_all line,
1859: ap_invoice_distributions_all dist,
1860: (SELECT distinct person_id
1861: ,national_identifier
1862: FROM PER_ALL_PEOPLE_F WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf
1863: WHERE vs.country = fl.lookup_code(+)
1864: AND 'JEES_EURO_COUNTRY_CODES' = fl.lookup_type
1865: AND (( p_vendor_id is null and v.vendor_id = v.vendor_id) or (v.vendor_id = p_vendor_id))
1866: AND nvl(v.employee_id,-99) = papf.person_id (+)

Line 2040: FROM PER_ALL_PEOPLE_F WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf

2036: ap_invoice_lines_all line,
2037: ap_invoice_distributions_all dist,
2038: (SELECT distinct person_id
2039: ,national_identifier
2040: FROM PER_ALL_PEOPLE_F WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf
2041: WHERE vs.country = fl.lookup_code(+)
2042: AND 'JEES_EURO_COUNTRY_CODES' = fl.lookup_type
2043: AND (( p_vendor_id is null and v.vendor_id = v.vendor_id) or (v.vendor_id = p_vendor_id))
2044: AND nvl(v.employee_id,-99) = papf.person_id (+)

Line 2175: FROM PER_ALL_PEOPLE_F WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf

2171: ap_invoice_lines_all line,
2172: ap_invoice_distributions_all dist,
2173: (SELECT distinct person_id
2174: ,national_identifier
2175: FROM PER_ALL_PEOPLE_F WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf
2176: WHERE vs.country = fl.lookup_code(+)
2177: AND 'JEES_EURO_COUNTRY_CODES' = fl.lookup_type
2178: AND (( p_vendor_id is null and v.vendor_id = v.vendor_id) or (v.vendor_id = p_vendor_id))
2179: AND nvl(v.employee_id,-99) = papf.person_id (+)