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 1552: lv_job_title per_jobs.name%TYPE;

1548: lv_current_forward_from_id per_people_f.person_id%TYPE ;
1549: lv_result VARCHAR2(20) DEFAULT 'N';
1550: ln_approver_index NUMBER DEFAULT 1;
1551: lv_full_name per_people_f.full_name%TYPE;
1552: lv_job_title per_jobs.name%TYPE;
1553: ln_assignment_id per_assignments_f.ASSIGNMENT_ID%TYPE;
1554: ld_effective_date per_assignments_f.EFFECTIVE_START_DATE%TYPE;
1555: lrt_assignment_details hr_misc_web.grt_assignment_details;
1556: l_proc constant varchar2(100) := g_package || ' get_ame_default_approvers';

Line 2018: lv_job_title per_jobs.name%TYPE;

2014: lv_current_forward_from_id per_people_f.person_id%TYPE ;
2015: lv_result VARCHAR2(20) DEFAULT 'N';
2016: ln_approver_index NUMBER DEFAULT 1;
2017: lv_full_name per_people_f.full_name%TYPE;
2018: lv_job_title per_jobs.name%TYPE;
2019: ln_assignment_id per_assignments_f.ASSIGNMENT_ID%TYPE;
2020: ld_effective_date per_assignments_f.EFFECTIVE_START_DATE%TYPE;
2021: lrt_assignment_details hr_misc_web.grt_assignment_details;
2022: l_proc constant varchar2(100) := g_package || ' get_default_approvers';