APPS.HXC_HXCMISTC_XMLP_PKG dependencies on PAY_PAYROLLS_F

Line 45: select pay.payroll_name from pay_payrolls_f pay

41: and ppf.effective_end_date;
42:
43: cursor c_payroll(cp_payroll_id in number,
44: cp_effective_date in date) is
45: select pay.payroll_name from pay_payrolls_f pay
46: where pay.payroll_id = cp_payroll_id
47: and cp_effective_date between pay.effective_start_date
48: and pay.effective_end_date;
49:

Line 292: L_PAYROLL_NAME PAY_PAYROLLS_F.PAYROLL_NAME%TYPE;

288: L_ASG_STATUS_TYPE_ID PER_ASSIGNMENTS_F.ASSIGNMENT_STATUS_TYPE_ID%TYPE;
289: L_PAYROLL_ID PER_ASSIGNMENTS_F.PAYROLL_ID%TYPE;
290: L_SOFT_CODING_KEYFLEX_ID PER_ASSIGNMENTS_F.SOFT_CODING_KEYFLEX_ID%TYPE;
291: L_PAY_SYSTEM_STATUS PER_ASSIGNMENT_STATUS_TYPES.PAY_SYSTEM_STATUS%TYPE;
292: L_PAYROLL_NAME PAY_PAYROLLS_F.PAYROLL_NAME%TYPE;
293: L_SCL_TCARD_REQ VARCHAR2(5);
294: BEGIN
295: RETURN L_PAYROLL_NAME;
296: END CF_APPLICATIONFORMULA;