APPS.HR_DYNAMIC_APPROVAL_WEB dependencies on PER_JOBS

Line 110: FROM per_jobs_vl pj,

106: p_assignment_id IN per_assignments_f.assignment_id%TYPE,
107: p_effective_date IN DATE
108: ) IS
109: SELECT pj.name
110: FROM per_jobs_vl pj,
111: per_assignments_f paf
112: WHERE paf.assignment_id = p_assignment_id
113: AND paf.job_id = pj.job_id
114: AND paf.primary_flag = 'Y'

Line 126: FROM per_jobs pj,

122: p_assignment_id IN per_assignments_f.assignment_id%TYPE,
123: p_effective_date IN DATE
124: ) IS
125: SELECT pj.job_id
126: FROM per_jobs pj,
127: per_assignments_f paf
128: WHERE paf.assignment_id = p_assignment_id
129: AND paf.job_id = pj.job_id
130: AND paf.primary_flag = 'Y'

Line 1588: lv_job_title per_jobs.name%TYPE;

1584: lv_current_forward_from_id per_people_f.person_id%TYPE ;
1585: lv_result VARCHAR2(20) DEFAULT 'N';
1586: ln_approver_index NUMBER DEFAULT 1;
1587: lv_full_name per_people_f.full_name%TYPE;
1588: lv_job_title per_jobs.name%TYPE;
1589: ln_assignment_id per_assignments_f.ASSIGNMENT_ID%TYPE;
1590: ld_effective_date per_assignments_f.EFFECTIVE_START_DATE%TYPE;
1591: lrt_assignment_details hr_misc_web.grt_assignment_details;
1592: l_proc constant varchar2(100) := g_package || ' get_ame_default_approvers';

Line 2079: lv_job_title per_jobs.name%TYPE;

2075: lv_current_forward_from_id per_people_f.person_id%TYPE ;
2076: lv_result VARCHAR2(20) DEFAULT 'N';
2077: ln_approver_index NUMBER DEFAULT 1;
2078: lv_full_name per_people_f.full_name%TYPE;
2079: lv_job_title per_jobs.name%TYPE;
2080: ln_assignment_id per_assignments_f.ASSIGNMENT_ID%TYPE;
2081: ld_effective_date per_assignments_f.EFFECTIVE_START_DATE%TYPE;
2082: lrt_assignment_details hr_misc_web.grt_assignment_details;
2083: l_proc constant varchar2(100) := g_package || ' get_default_approvers';