APPS.PAY_NO_EMP_CONT_2007 dependencies on HR_ORGANIZATION_UNITS

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

146:
147:
148: -- cursor to get Name of Organisation (LE or LU) from org_id
149:
150: CURSOR csr_org_name (p_org_id HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE ,
151: p_bus_group_id HR_ORGANIZATION_UNITS.BUSINESS_GROUP_ID%TYPE ) IS
152: SELECT NAME
153: FROM HR_ORGANIZATION_UNITS
154: WHERE ORGANIZATION_ID = p_org_id

Line 151: p_bus_group_id HR_ORGANIZATION_UNITS.BUSINESS_GROUP_ID%TYPE ) IS

147:
148: -- cursor to get Name of Organisation (LE or LU) from org_id
149:
150: CURSOR csr_org_name (p_org_id HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE ,
151: p_bus_group_id HR_ORGANIZATION_UNITS.BUSINESS_GROUP_ID%TYPE ) IS
152: SELECT NAME
153: FROM HR_ORGANIZATION_UNITS
154: WHERE ORGANIZATION_ID = p_org_id
155: AND BUSINESS_GROUP_ID = p_bus_group_id ;

Line 153: FROM HR_ORGANIZATION_UNITS

149:
150: CURSOR csr_org_name (p_org_id HR_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE ,
151: p_bus_group_id HR_ORGANIZATION_UNITS.BUSINESS_GROUP_ID%TYPE ) IS
152: SELECT NAME
153: FROM HR_ORGANIZATION_UNITS
154: WHERE ORGANIZATION_ID = p_org_id
155: AND BUSINESS_GROUP_ID = p_bus_group_id ;
156:
157: