APPS.GHR_PAY_CALC dependencies on PER_ASSIGNMENTS_F

Line 3297: l_assignment_id per_assignments_f.assignment_id%type;

3293: IS
3294: l_asg_ei_data per_assignment_extra_info%rowtype;
3295: l_prd per_assignment_extra_info.aei_information6%type;
3296: l_dummy VARCHAR2(30);
3297: l_assignment_id per_assignments_f.assignment_id%type;
3298: l_from_position_id ghr_pa_requests.from_position_id%type;
3299: l_from_pay_basis ghr_pa_requests.from_pay_basis%type;
3300: l_pos_ei_grade_data per_position_extra_info%rowtype;
3301:

Line 3304: FROM per_assignments_f paf

3300: l_pos_ei_grade_data per_position_extra_info%rowtype;
3301:
3302: CURSOR get_asgn_pos(c_person_id IN ghr_pa_requests.person_id%type, c_effective_date IN ghr_pa_requests.effective_date%type) IS
3303: SELECT paf.assignment_id, paf.position_id
3304: FROM per_assignments_f paf
3305: WHERE paf.person_id = c_person_id
3306: AND trunc(nvl(c_effective_date,sysdate))between paf.effective_start_date and paf.effective_end_date
3307: AND paf.primary_flag = 'Y'
3308: AND paf.assignment_type <> 'B';

Line 3408: l_assignment_id per_assignments_f.assignment_id%type;

3404: FROM pay_user_tables utb
3405: WHERE utb.user_table_name = ghr_pay_calc.l_standard_table_name;
3406:
3407: ----
3408: l_assignment_id per_assignments_f.assignment_id%type;
3409: l_value varchar2(60);
3410: l_multi_error_flag BOOLEAN;
3411: l_gm_unadjd_basic_pay Number;
3412:

Line 3417: FROM per_assignments_f paf

3413: CURSOR get_asgn_pos (c_person_id IN ghr_pa_requests.person_id%type,
3414: c_effective_date IN ghr_pa_requests.effective_date%type)
3415: IS
3416: SELECT paf.assignment_id
3417: FROM per_assignments_f paf
3418: WHERE paf.person_id = c_person_id
3419: AND trunc(nvl(c_effective_date,sysdate))between paf.effective_start_date and paf.effective_end_date
3420: AND paf.primary_flag = 'Y'
3421: AND paf.assignment_type <> 'B';

Line 3585: l_assignment_id per_assignments_f.assignment_id%type;

3581: FROM pay_user_tables utb
3582: WHERE utb.user_table_name = ghr_pay_calc.l_standard_table_name;
3583:
3584: ----
3585: l_assignment_id per_assignments_f.assignment_id%type;
3586: l_value varchar2(60);
3587: l_multi_error_flag BOOLEAN;
3588: l_gm_unadjd_basic_pay Number;
3589:

Line 3594: FROM per_assignments_f paf

3590: CURSOR get_asgn_pos (c_person_id IN ghr_pa_requests.person_id%type,
3591: c_effective_date IN ghr_pa_requests.effective_date%type)
3592: IS
3593: SELECT paf.assignment_id
3594: FROM per_assignments_f paf
3595: WHERE paf.person_id = c_person_id
3596: AND trunc(nvl(c_effective_date,sysdate))between paf.effective_start_date and paf.effective_end_date
3597: AND paf.primary_flag = 'Y'
3598: AND paf.assignment_type <> 'B';