APPS.PAY_PYAURECP_XMLP_PKG dependencies on HR_AU_LEG_EMP_V
Line 24: CURSOR C_REG_EMP(C_ORG_ID IN HR_AU_LEG_EMP_V.ORGANIZATION_ID%TYPE) IS
20: ,4)
21: ,'DD-MM-YYYY') FBT_YEAR_END
22: FROM
23: DUAL; 24: CURSOR C_REG_EMP(C_ORG_ID IN HR_AU_LEG_EMP_V.ORGANIZATION_ID%TYPE) IS 25: SELECT
26: NAME
27: FROM
28: HR_AU_LEG_EMP_V
Line 28: HR_AU_LEG_EMP_V
24: CURSOR C_REG_EMP(C_ORG_ID IN HR_AU_LEG_EMP_V.ORGANIZATION_ID%TYPE) IS
25: SELECT
26: NAME
27: FROM 28: HR_AU_LEG_EMP_V 29: WHERE ORGANIZATION_ID = C_ORG_ID;
30: CURSOR C_PAYROLL_INFO(C_PAYROLL_ID IN NUMBER) IS
31: SELECT
32: PPF.PAYROLL_NAME