APPS.HXC_HXCMISTC_XMLP_PKG dependencies on PAY_PAYROLLS_F

Line 41: PAY_PAYROLLS_F PAY

37: CURSOR C_PAYROLL(CP_PAYROLL_ID IN NUMBER,CP_EFFECTIVE_DATE IN DATE) IS
38: SELECT
39: PAY.PAYROLL_NAME
40: FROM
41: PAY_PAYROLLS_F PAY
42: WHERE PAY.PAYROLL_ID = CP_PAYROLL_ID
43: AND CP_EFFECTIVE_DATE between PAY.EFFECTIVE_START_DATE
44: AND PAY.EFFECTIVE_END_DATE;
45: CURSOR C_VENDOR(P_VENDOR_ID IN NUMBER) IS

Line 254: L_PAYROLL_NAME PAY_PAYROLLS_F.PAYROLL_NAME%TYPE;

250: L_ASG_STATUS_TYPE_ID PER_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID%TYPE;
251: L_PAYROLL_ID PER_ASSIGNMENTS_F.PAYROLL_ID%TYPE;
252: L_SOFT_CODING_KEYFLEX_ID PER_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID%TYPE;
253: L_PAY_SYSTEM_STATUS PER_ASSIGNMENT_STATUS_TYPES.PAY_SYSTEM_STATUS%TYPE;
254: L_PAYROLL_NAME PAY_PAYROLLS_F.PAYROLL_NAME%TYPE;
255: L_SCL_TCARD_REQ VARCHAR2(5);
256: BEGIN
257: RETURN L_PAYROLL_NAME;
258: END CF_APPLICATIONFORMULA;