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.PQH_LENGTH_OF_SERVICE_PKG dependencies on PER_PREVIOUS_EMPLOYERS

Line 460: from per_previous_employers pem, per_previous_jobs pjo, per_previous_job_usages pju

456: nvl(pjo.start_date, trunc(sysdate)) pjo_start_date,
457: nvl(pjo.end_date, trunc(sysdate)) pjo_end_date,
458: nvl(pju.start_date, trunc(sysdate)) pju_start_date,
459: nvl(pju.end_date, trunc(sysdate)) pju_end_date
460: from per_previous_employers pem, per_previous_jobs pjo, per_previous_job_usages pju
461: where
462: pem.previous_employer_id = pjo.previous_employer_id(+)
463: and
464: pjo.previous_job_id = pju.previous_job_id(+)

Line 2366: l_employer_type per_previous_employers.employer_type%TYPE := 'x';

2362: l_prev_step_id per_previous_jobs.pjo_information3%TYPE;
2363: l_curr_grade_id per_assignments_f.grade_id%TYPE;
2364: l_curr_step_id per_spinal_point_placements_f.step_id%TYPE;
2365: l_emp_type per_previous_jobs.employment_category%TYPE := 'x';
2366: l_employer_type per_previous_employers.employer_type%TYPE := 'x';
2367: l_prev_empl_id per_previous_employers.previous_employer_id%TYPE;
2368: l_person_id per_all_people_f.person_id%TYPE;
2369: l_bg_id per_all_organization_units.organization_id%TYPE := p_bg_id;
2370: l_entitlement pqh_situations.entitlement_value%TYPE :=0;

Line 2367: l_prev_empl_id per_previous_employers.previous_employer_id%TYPE;

2363: l_curr_grade_id per_assignments_f.grade_id%TYPE;
2364: l_curr_step_id per_spinal_point_placements_f.step_id%TYPE;
2365: l_emp_type per_previous_jobs.employment_category%TYPE := 'x';
2366: l_employer_type per_previous_employers.employer_type%TYPE := 'x';
2367: l_prev_empl_id per_previous_employers.previous_employer_id%TYPE;
2368: l_person_id per_all_people_f.person_id%TYPE;
2369: l_bg_id per_all_organization_units.organization_id%TYPE := p_bg_id;
2370: l_entitlement pqh_situations.entitlement_value%TYPE :=0;
2371: l_assignment_id per_all_assignments_f.assignment_id%TYPE := p_assignment_id;

Line 2398: FROM per_previous_employers

2394: AND end_date = l_end_date;
2395:
2396: CURSOR c_prev_employers IS
2397: SELECT nvl(employer_type,'x')
2398: FROM per_previous_employers
2399: WHERE previous_employer_id = l_prev_empl_id;
2400:
2401: CURSOR c_person_dob IS
2402: SELECT date_of_birth