APPS.PAY_GB_STUDENT_LOANS_PKG dependencies on PAY_PAYROLLS_F

Line 464: pay_payrolls_f ppf,

460: CURSOR get_asg_tax_ref IS
461: SELECT scl.segment1
462: FROM hr_soft_coding_keyflex scl,
463: fnd_sessions fs,
464: pay_payrolls_f ppf,
465: per_all_assignments_f paaf
466: WHERE paaf.assignment_id = p_assignment_id
467: AND fs.session_id = userenv('sessionid')
468: AND fs.effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date

Line 816: l_asg_payroll_id pay_payrolls_f.payroll_id%TYPE;

812: ) RETURN DATE IS
813:
814:
815: l_asg_tax_ref hr_soft_coding_keyflex.segment1%TYPE;
816: l_asg_payroll_id pay_payrolls_f.payroll_id%TYPE;
817: l_asg_period_start_date per_time_periods.start_date%TYPE;
818: g_cto_main_iv_id NUMBER;
819: g_cto_ntpp_main_iv_id NUMBER;
820: g_cto_main_ref_id NUMBER;