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_CA_GROUP_LEVEL_BAL_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 113: pay_all_payrolls_f pay

109: CURSOR csr_asg_in_payroll(p_asg_id NUMBER,
110: p_date DATE) IS
111: SELECT 'X'
112: FROM per_all_assignments_f asg,
113: pay_all_payrolls_f pay
114: WHERE asg.assignment_id = p_asg_id
115: AND p_date BETWEEN asg.effective_start_date
116: AND asg.effective_end_date
117: AND asg.payroll_id = pay.payroll_id

Line 125: FROM pay_all_payrolls_f pay,

121: CURSOR csr_get_virtual_date(p_asg_id NUMBER,
122: p_date DATE,
123: p_date_mask VARCHAR2) IS
124: SELECT MAX(pay.effective_end_date)
125: FROM pay_all_payrolls_f pay,
126: per_all_assignments_f asg
127: WHERE asg.assignment_id = p_asg_id
128: AND asg.payroll_id = pay.payroll_id
129: AND pay.effective_end_date BETWEEN TRUNC(p_date, p_date_mask)