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 3658: FROM hr_organization_units hou

3654: CURSOR csr_own_risk_cover(c_employer_id NUMBER
3655: ,c_business_group_id NUMBER) IS
3656: SELECT hoi.org_information5 Own_Risk_Cover
3657: ,hoi.org_information6 Contract_Code_Mapping
3658: FROM hr_organization_units hou
3659: ,hr_organization_information hoi
3660: WHERE hoi.org_information_context = 'NL_ORG_WR_INFO'
3661: AND hou.business_group_id = c_business_group_id
3662: AND hou.organization_id = hoi.organization_id

Line 3668: FROM hr_organization_units hou,hr_organization_information hoi

3664: --
3665: CURSOR csr_public_org_flag(c_employer_id NUMBER
3666: ,c_business_group_id NUMBER) IS
3667: SELECT hoi.org_information17 Public_Org
3668: FROM hr_organization_units hou,hr_organization_information hoi
3669: WHERE hoi.org_information_context = 'NL_ORG_INFORMATION'
3670: AND hou.business_group_id = c_business_group_id
3671: AND hou.organization_id = hoi.organization_id
3672: AND hou.organization_id = c_employer_id;

Line 3783: FROM hr_organization_units hou,hr_organization_information hoi

3779: ,c_business_group_id NUMBER) IS
3780: SELECT hoi.org_information1 sender_id
3781: ,hoi.org_information2 contact_name
3782: ,hoi.org_information3 contact_num
3783: FROM hr_organization_units hou,hr_organization_information hoi
3784: WHERE hoi.org_information_context = 'NL_ORG_WR_INFO'
3785: AND hou.business_group_id = c_business_group_id
3786: AND hou.organization_id = hoi.organization_id
3787: AND hou.organization_id = c_employer_id;

Line 3794: FROM hr_organization_units hou

3790: CURSOR csr_tax_details(c_employer_id NUMBER
3791: ,c_business_group_id NUMBER) IS
3792: SELECT hoi.org_information14 tax_rep_name
3793: ,hoi.org_information4 tax_reg_num
3794: FROM hr_organization_units hou
3795: ,hr_organization_information hoi
3796: WHERE hoi.org_information_context = 'NL_ORG_INFORMATION'
3797: AND hou.business_group_id = c_business_group_id
3798: AND hou.organization_id = hoi.organization_id

Line 3981: FROM hr_organization_units hou,hr_organization_information hoi

3977: ,c_business_group_id NUMBER) IS
3978: SELECT hoi.org_information1 sender_id
3979: ,hoi.org_information2 contact_name
3980: ,hoi.org_information3 contact_num
3981: FROM hr_organization_units hou,hr_organization_information hoi
3982: WHERE hoi.org_information_context = 'NL_ORG_WR_INFO'
3983: AND hou.business_group_id = c_business_group_id
3984: AND hou.organization_id = hoi.organization_id
3985: AND hou.organization_id = c_employer_id;

Line 3992: FROM hr_organization_units hou

3988: CURSOR csr_tax_details(c_employer_id NUMBER
3989: ,c_business_group_id NUMBER) IS
3990: SELECT hoi.org_information14 tax_rep_name
3991: ,hoi.org_information4 tax_reg_num
3992: FROM hr_organization_units hou
3993: ,hr_organization_information hoi
3994: WHERE hoi.org_information_context = 'NL_ORG_INFORMATION'
3995: AND hou.business_group_id = c_business_group_id
3996: AND hou.organization_id = hoi.organization_id

Line 4286: FROM hr_organization_units hou,hr_organization_information hoi

4282: ,c_business_group_id NUMBER) IS
4283: SELECT hoi.org_information1 sender_id
4284: ,hoi.org_information2 contact_name
4285: ,hoi.org_information3 contact_num
4286: FROM hr_organization_units hou,hr_organization_information hoi
4287: WHERE hoi.org_information_context = 'NL_ORG_WR_INFO'
4288: AND hou.business_group_id = c_business_group_id
4289: AND hou.organization_id = hoi.organization_id
4290: AND hou.organization_id = c_employer_id;

Line 4297: FROM hr_organization_units hou

4293: CURSOR csr_tax_details(c_employer_id NUMBER
4294: ,c_business_group_id NUMBER) IS
4295: SELECT hoi.org_information14 tax_rep_name
4296: ,hoi.org_information4 tax_reg_num
4297: FROM hr_organization_units hou
4298: ,hr_organization_information hoi
4299: WHERE hoi.org_information_context = 'NL_ORG_INFORMATION'
4300: AND hou.business_group_id = c_business_group_id
4301: AND hou.organization_id = hoi.organization_id

Line 7255: FROM hr_organization_units hou,hr_organization_information hoi

7251: --
7252: CURSOR csr_get_empr_contact(c_employer_id NUMBER
7253: ,c_business_group_id NUMBER) IS
7254: SELECT hoi.org_information4 paid_flag
7255: FROM hr_organization_units hou,hr_organization_information hoi
7256: WHERE hoi.org_information_context = 'NL_ORG_WR_INFO'
7257: AND hou.business_group_id = c_business_group_id
7258: AND hou.organization_id = hoi.organization_id
7259: AND hou.organization_id = c_employer_id;