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_NL_PAYFILE dependencies on HR_GENERAL

Line 466: SELECT substr(hr_general.decode_lookup('HR_NL_CITY',town_or_city),1,35) town_or_city

462: AND p_effective_date BETWEEN pas.date_from
463: AND nvl(pas.date_to,to_date('31/12/4712','DD/MM/YYYY'));
464: --
465: CURSOR csr_get_per_address(p_payee_id NUMBER) IS -- to get the city when address style is Netherlands
466: SELECT substr(hr_general.decode_lookup('HR_NL_CITY',town_or_city),1,35) town_or_city
467: FROM per_addresses pas
468: WHERE pas.person_id = p_payee_id
469: AND pas.primary_flag = 'Y'
470: AND p_effective_date BETWEEN pas.date_from

Line 482: SELECT substr(hr_general.decode_lookup('HR_NL_CITY',town_or_city),1,35) town_or_city

478: AND p_effective_date BETWEEN pas.date_from
479: AND nvl(pas.date_to,to_date('31/12/4712','DD/MM/YYYY'));
480: --
481: CURSOR csr_get_org_address(p_payee_id NUMBER) IS
482: SELECT substr(hr_general.decode_lookup('HR_NL_CITY',town_or_city),1,35) town_or_city
483: FROM hr_locations_all hla
484: ,hr_all_organization_units hou
485: WHERE hou.organization_id = p_payee_id
486: AND hou.location_id = hla.location_id;