APPS.GHR_PAY_CALC dependencies on PER_ASSIGNMENTS_F

Line 3511: l_assignment_id per_assignments_f.assignment_id%type;

3507: IS
3508: l_asg_ei_data per_assignment_extra_info%rowtype;
3509: l_prd per_assignment_extra_info.aei_information6%type;
3510: l_dummy VARCHAR2(30);
3511: l_assignment_id per_assignments_f.assignment_id%type;
3512: l_from_position_id ghr_pa_requests.from_position_id%type;
3513: l_from_pay_basis ghr_pa_requests.from_pay_basis%type;
3514: l_pos_ei_grade_data per_position_extra_info%rowtype;
3515:

Line 3518: FROM per_assignments_f paf

3514: l_pos_ei_grade_data per_position_extra_info%rowtype;
3515:
3516: 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
3517: SELECT paf.assignment_id, paf.position_id
3518: FROM per_assignments_f paf
3519: WHERE paf.person_id = c_person_id
3520: AND trunc(nvl(c_effective_date,sysdate))between paf.effective_start_date and paf.effective_end_date
3521: AND paf.primary_flag = 'Y'
3522: AND paf.assignment_type <> 'B';

Line 3622: l_assignment_id per_assignments_f.assignment_id%type;

3618: FROM pay_user_tables utb
3619: WHERE utb.user_table_name = ghr_pay_calc.l_standard_table_name;
3620:
3621: ----
3622: l_assignment_id per_assignments_f.assignment_id%type;
3623: l_value varchar2(60);
3624: l_multi_error_flag BOOLEAN;
3625: l_gm_unadjd_basic_pay Number;
3626:

Line 3631: FROM per_assignments_f paf

3627: CURSOR get_asgn_pos (c_person_id IN ghr_pa_requests.person_id%type,
3628: c_effective_date IN ghr_pa_requests.effective_date%type)
3629: IS
3630: SELECT paf.assignment_id
3631: FROM per_assignments_f paf
3632: WHERE paf.person_id = c_person_id
3633: AND trunc(nvl(c_effective_date,sysdate))between paf.effective_start_date and paf.effective_end_date
3634: AND paf.primary_flag = 'Y'
3635: AND paf.assignment_type <> 'B';

Line 3799: l_assignment_id per_assignments_f.assignment_id%type;

3795: FROM pay_user_tables utb
3796: WHERE utb.user_table_name = ghr_pay_calc.l_standard_table_name;
3797:
3798: ----
3799: l_assignment_id per_assignments_f.assignment_id%type;
3800: l_value varchar2(60);
3801: l_multi_error_flag BOOLEAN;
3802: l_gm_unadjd_basic_pay Number;
3803:

Line 3808: FROM per_assignments_f paf

3804: CURSOR get_asgn_pos (c_person_id IN ghr_pa_requests.person_id%type,
3805: c_effective_date IN ghr_pa_requests.effective_date%type)
3806: IS
3807: SELECT paf.assignment_id
3808: FROM per_assignments_f paf
3809: WHERE paf.person_id = c_person_id
3810: AND trunc(nvl(c_effective_date,sysdate))between paf.effective_start_date and paf.effective_end_date
3811: AND paf.primary_flag = 'Y'
3812: AND paf.assignment_type <> 'B';