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.PQP_CAR_MILEAGE_FUNCTIONS dependencies on PER_ASSIGNMENTS_F

Line 1150: l_person_id PER_ASSIGNMENTS_F.person_id%TYPE;

1146: l_fiscal_year_begin DATE;
1147: l_fiscal_year_end DATE;
1148: l_cur_year VARCHAR2(5);
1149: l_asg_year VARCHAR2(5);
1150: l_person_id PER_ASSIGNMENTS_F.person_id%TYPE;
1151: l_dummy VARCHAR2(1);
1152: l_effective_date DATE;
1153:
1154: BEGIN

Line 2513: ,per_assignments_f pas

2509: CURSOR c_get_term_date
2510: IS
2511: SELECT DECODE(NVL(TO_CHAR(pds.actual_termination_date), 'N'), 'N', 'N', 'Y') term_date
2512: FROM per_periods_of_service pds
2513: ,per_assignments_f pas
2514: WHERE pds.actual_termination_date <= p_date_earned
2515: AND pds.period_of_service_id = pas.period_of_service_id
2516: AND p_date_earned BETWEEN pas.effective_start_date
2517: AND pas.effective_end_date