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_GET_TAX_EXISTS_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 293: from per_all_assignments_f

289: l_is_valid_location boolean ;
290:
291: cursor c_multiple_assignments is
292: select assignment_id
293: from per_all_assignments_f
294: where TO_DATE(p_date_earned, 'dd-mm-yyyy') between effective_start_date
295: and effective_end_date
296: and person_id in (select person_id
297: from per_all_assignments_f

Line 297: from per_all_assignments_f

293: from per_all_assignments_f
294: where TO_DATE(p_date_earned, 'dd-mm-yyyy') between effective_start_date
295: and effective_end_date
296: and person_id in (select person_id
297: from per_all_assignments_f
298: where assignment_id =p_assign_id);
299: /*Bug#6768746: Changes ends here*/
300:
301: CURSOR c_override_location IS

Line 713: per_all_assignments_f ASSIGN

709: cursor override_state is
710: select nvl(ADDR.add_information17,'ZZ')
711: from
712: per_addresses ADDR,
713: per_all_assignments_f ASSIGN
714: where TO_DATE(l_date_earned, 'dd-mm-yyyy')
715: between ASSIGN.effective_start_date
716: and ASSIGN.effective_end_date
717: and ASSIGN.assignment_id = p_assign_id

Line 2143: per_all_assignments_f asg

2139:
2140: CURSOR override_state IS
2141: SELECT NVL(addr.add_information17,'ZZ')
2142: FROM per_addresses addr,
2143: per_all_assignments_f asg
2144: WHERE TO_DATE(l_date_earned, 'dd-mm-yyyy')
2145: BETWEEN asg.effective_start_date
2146: AND asg.effective_end_date
2147: AND asg.assignment_id = p_assign_id