APPS.HR_DYNAMIC_APPROVAL_WEB dependencies on PER_ASSIGNMENTS_F

Line 106: p_assignment_id IN per_assignments_f.assignment_id%TYPE,

102:
103:
104: -- CURSOR FOR JOB TITLE
105: CURSOR gc_job_details (
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,

Line 111: per_assignments_f paf

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'
115: AND paf.business_group_id+0 = pj.business_group_id+0

Line 122: p_assignment_id IN per_assignments_f.assignment_id%TYPE,

118: ORDER BY paf.effective_start_date DESC;
119:
120: -- cursor for JOB ID
121: CURSOR gc_job_id (
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,

Line 127: per_assignments_f paf

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'
131: AND paf.business_group_id+0 = pj.business_group_id+0

Line 1553: ln_assignment_id per_assignments_f.ASSIGNMENT_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';
1557: --my new variables

Line 1554: ld_effective_date per_assignments_f.EFFECTIVE_START_DATE%TYPE;

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';
1557: --my new variables
1558: lv_approver_name hr_util_misc_web.g_varchar2_tab_type DEFAULT

Line 1689: ln_assignment_id per_assignments_f.assignment_id%TYPE;

1685: lv_item_name VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
1686: l_dummy VARCHAR2(100);
1687: ln_def_app_index NUMBER DEFAULT 1;
1688: ln_person_id per_people_f.person_id%TYPE;
1689: ln_assignment_id per_assignments_f.assignment_id%TYPE;
1690: lrt_assignment_details hr_misc_web.grt_assignment_details;
1691: lv_approver_deleted VARCHAR2(100) DEFAULT NULL;
1692: lv_default_approver VARCHAR2(100) DEFAULT 'NO';
1693: ln_error_count NUMBER DEFAULT 1;

Line 2019: ln_assignment_id per_assignments_f.ASSIGNMENT_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';
2023: --my new variables

Line 2020: ld_effective_date per_assignments_f.EFFECTIVE_START_DATE%TYPE;

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';
2023: --my new variables
2024: lv_approver_name hr_util_misc_web.g_varchar2_tab_type DEFAULT

Line 2237: ln_assignment_id per_assignments_f.assignment_id%TYPE;

2233: lv_item_name VARCHAR2(100) DEFAULT 'ADDITIONAL_APPROVER_';
2234: l_dummy VARCHAR2(100);
2235: ln_def_app_index NUMBER DEFAULT 1;
2236: ln_person_id per_people_f.person_id%TYPE;
2237: ln_assignment_id per_assignments_f.assignment_id%TYPE;
2238: lrt_assignment_details hr_misc_web.grt_assignment_details;
2239: lv_approver_deleted VARCHAR2(100) DEFAULT NULL;
2240: lv_default_approver VARCHAR2(100) DEFAULT 'NO';
2241: ln_error_count NUMBER DEFAULT 1;