APPS.PAY_PYAURECP_XMLP_PKG dependencies on PAY_PAYROLLS_F

Line 34: PAY_PAYROLLS_F PPF

30: CURSOR C_PAYROLL_INFO(C_PAYROLL_ID IN NUMBER) IS
31: SELECT
32: PPF.PAYROLL_NAME
33: FROM
34: PAY_PAYROLLS_F PPF
35: WHERE PPF.PAYROLL_ID = C_PAYROLL_ID
36: AND PPF.EFFECTIVE_START_DATE = (
37: SELECT
38: MAX(PPF1.EFFECTIVE_START_DATE)

Line 40: PAY_PAYROLLS_F PPF1

36: AND PPF.EFFECTIVE_START_DATE = (
37: SELECT
38: MAX(PPF1.EFFECTIVE_START_DATE)
39: FROM
40: PAY_PAYROLLS_F PPF1
41: WHERE PPF1.PAYROLL_ID = PPF.PAYROLL_ID );
42: CURSOR C_HL_MEANING(C_HL_CODE IN HR_LOOKUPS.LOOKUP_CODE%TYPE) IS
43: SELECT
44: HL.MEANING