eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_STUDENT_LOANS_PKG dependencies on PAY_PAYROLLS_F

Line 466: pay_payrolls_f ppf,

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

Line 818: l_asg_payroll_id pay_payrolls_f.payroll_id%TYPE;

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

Line 1782: select period_type from pay_payrolls_f where

1778: return varchar2
1779: is
1780: l_payroll varchar2(20);
1781: cursor c_payroll is
1782: select period_type from pay_payrolls_f where
1783: payroll_id in (select payroll_id from per_all_assignments_f where assignment_id = p_asg_id
1784: and p_date_earned between effective_start_date and effective_end_date)
1785: and p_date_earned between effective_start_date and effective_end_date;
1786: