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_FR_GENERAL dependencies on HR_ORGANIZATION_INFORMATION

Line 902: from hr_organization_information oi1

898: is
899:
900: cursor estab_pen_prvs_csr is
901: select oi1.org_information4 order_number
902: from hr_organization_information oi1
903: where oi1.organization_id = p_establishment_id
904: and oi1.org_information_context = 'FR_ESTAB_PE_PRVS'
905: and oi1.org_information1 = p_emp_pension_provider_id;
906:

Line 909: from hr_organization_information oi1

905: and oi1.org_information1 = p_emp_pension_provider_id;
906:
907: cursor estab_default_pen_prvs_csr is
908: select oi1.org_information4 order_number
909: from hr_organization_information oi1
910: , hr_organization_information oi2
911: where oi1.organization_id = p_establishment_id
912: and oi1.org_information_context = 'FR_ESTAB_PE_PRVS'
913: and oi1.org_information3 = 'Y'

Line 910: , hr_organization_information oi2

906:
907: cursor estab_default_pen_prvs_csr is
908: select oi1.org_information4 order_number
909: from hr_organization_information oi1
910: , hr_organization_information oi2
911: where oi1.organization_id = p_establishment_id
912: and oi1.org_information_context = 'FR_ESTAB_PE_PRVS'
913: and oi1.org_information3 = 'Y'
914: and oi1.org_information1 = oi2.organization_id