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

Line 206: CURSOR csr_org_name (p_org_id HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE ,

202: /* Bug No. : 4474602 and 4463136 */
203:
204: -- cursor to get Name of Organisation (LE or LU) from org_id
205:
206: CURSOR csr_org_name (p_org_id HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE ,
207: p_bus_group_id HR_ORGANIZATION_UNITS.BUSINESS_GROUP_ID%TYPE ) IS
208: SELECT NAME
209: FROM HR_ORGANIZATION_UNITS
210: WHERE ORGANIZATION_ID = p_org_id

Line 207: p_bus_group_id HR_ORGANIZATION_UNITS.BUSINESS_GROUP_ID%TYPE ) IS

203:
204: -- cursor to get Name of Organisation (LE or LU) from org_id
205:
206: CURSOR csr_org_name (p_org_id HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE ,
207: p_bus_group_id HR_ORGANIZATION_UNITS.BUSINESS_GROUP_ID%TYPE ) IS
208: SELECT NAME
209: FROM HR_ORGANIZATION_UNITS
210: WHERE ORGANIZATION_ID = p_org_id
211: AND BUSINESS_GROUP_ID = p_bus_group_id ;

Line 209: FROM HR_ORGANIZATION_UNITS

205:
206: CURSOR csr_org_name (p_org_id HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE ,
207: p_bus_group_id HR_ORGANIZATION_UNITS.BUSINESS_GROUP_ID%TYPE ) IS
208: SELECT NAME
209: FROM HR_ORGANIZATION_UNITS
210: WHERE ORGANIZATION_ID = p_org_id
211: AND BUSINESS_GROUP_ID = p_bus_group_id ;
212:
213: /* Bug No. : 4474602 and 4463136 */