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_WAGE_REPORT_PKG dependencies on HR_ORGANIZATION_UNITS

Line 2489: FROM hr_organization_units hou

2485: CURSOR csr_own_risk_cover(c_employer_id NUMBER
2486: ,c_business_group_id NUMBER) IS
2487: SELECT hoi.org_information5 Own_Risk_Cover
2488: ,hoi.org_information6 Contract_Code_Mapping
2489: FROM hr_organization_units hou
2490: ,hr_organization_information hoi
2491: WHERE hoi.org_information_context = 'NL_ORG_WR_INFO'
2492: AND hou.business_group_id = c_business_group_id
2493: AND hou.organization_id = hoi.organization_id

Line 2499: FROM hr_organization_units hou,hr_organization_information hoi

2495: --
2496: CURSOR csr_public_org_flag(c_employer_id NUMBER
2497: ,c_business_group_id NUMBER) IS
2498: SELECT hoi.org_information17 Public_Org
2499: FROM hr_organization_units hou,hr_organization_information hoi
2500: WHERE hoi.org_information_context = 'NL_ORG_INFORMATION'
2501: AND hou.business_group_id = c_business_group_id
2502: AND hou.organization_id = hoi.organization_id
2503: AND hou.organization_id = c_employer_id;

Line 2607: FROM hr_organization_units hou,hr_organization_information hoi

2603: ,c_business_group_id NUMBER) IS
2604: SELECT hoi.org_information1 sender_id
2605: ,hoi.org_information2 contact_name
2606: ,hoi.org_information3 contact_num
2607: FROM hr_organization_units hou,hr_organization_information hoi
2608: WHERE hoi.org_information_context = 'NL_ORG_WR_INFO'
2609: AND hou.business_group_id = c_business_group_id
2610: AND hou.organization_id = hoi.organization_id
2611: AND hou.organization_id = c_employer_id;

Line 2618: FROM hr_organization_units hou

2614: CURSOR csr_tax_details(c_employer_id NUMBER
2615: ,c_business_group_id NUMBER) IS
2616: SELECT hoi.org_information14 tax_rep_name
2617: ,hoi.org_information4 tax_reg_num
2618: FROM hr_organization_units hou
2619: ,hr_organization_information hoi
2620: WHERE hoi.org_information_context = 'NL_ORG_INFORMATION'
2621: AND hou.business_group_id = c_business_group_id
2622: AND hou.organization_id = hoi.organization_id

Line 2768: FROM hr_organization_units hou,hr_organization_information hoi

2764: ,c_business_group_id NUMBER) IS
2765: SELECT hoi.org_information1 sender_id
2766: ,hoi.org_information2 contact_name
2767: ,hoi.org_information3 contact_num
2768: FROM hr_organization_units hou,hr_organization_information hoi
2769: WHERE hoi.org_information_context = 'NL_ORG_WR_INFO'
2770: AND hou.business_group_id = c_business_group_id
2771: AND hou.organization_id = hoi.organization_id
2772: AND hou.organization_id = c_employer_id;

Line 2779: FROM hr_organization_units hou

2775: CURSOR csr_tax_details(c_employer_id NUMBER
2776: ,c_business_group_id NUMBER) IS
2777: SELECT hoi.org_information14 tax_rep_name
2778: ,hoi.org_information4 tax_reg_num
2779: FROM hr_organization_units hou
2780: ,hr_organization_information hoi
2781: WHERE hoi.org_information_context = 'NL_ORG_INFORMATION'
2782: AND hou.business_group_id = c_business_group_id
2783: AND hou.organization_id = hoi.organization_id

Line 4367: FROM hr_organization_units hou,hr_organization_information hoi

4363: --
4364: CURSOR csr_get_empr_contact(c_employer_id NUMBER
4365: ,c_business_group_id NUMBER) IS
4366: SELECT hoi.org_information4 paid_flag
4367: FROM hr_organization_units hou,hr_organization_information hoi
4368: WHERE hoi.org_information_context = 'NL_ORG_WR_INFO'
4369: AND hou.business_group_id = c_business_group_id
4370: AND hou.organization_id = hoi.organization_id
4371: AND hou.organization_id = c_employer_id;