DBA Data[Home] [Help]

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