APPS.GHR_MSL_PKG dependencies on GHR_DUTY_STATIONS_F

Line 397: ,p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE

393: ,p_position_title IN VARCHAR2
394: ,p_position_number IN VARCHAR2
395: ,p_position_seq_no IN VARCHAR2
396: ,p_subelem_code IN VARCHAR2
397: ,p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
398: ,p_tenure IN VARCHAR2
399: ,p_annuitant_indicator IN VARCHAR2
400: ,p_pay_rate_determinant IN VARCHAR2
401: ,p_work_schedule IN VARCHAR2

Line 416: FROM ghr_duty_stations_f

412: -- Bug3437354
413: CURSOR cur_valid_DS(p_ds_id NUMBER)
414: IS
415: SELECT effective_end_date end_date
416: FROM ghr_duty_stations_f
417: WHERE duty_station_id=p_ds_id
418: AND g_effective_date between effective_start_date and effective_end_date;
419:
420: l_ds_end_date ghr_duty_stations_f.effective_end_date%type;

Line 420: l_ds_end_date ghr_duty_stations_f.effective_end_date%type;

416: FROM ghr_duty_stations_f
417: WHERE duty_station_id=p_ds_id
418: AND g_effective_date between effective_start_date and effective_end_date;
419:
420: l_ds_end_date ghr_duty_stations_f.effective_end_date%type;
421:
422: BEGIN
423: savepoint execute_msl_sp;
424: l_msl_cnt := l_msl_cnt +1;

Line 2828: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE

2824: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
2825: ,p_location_id IN per_assignments_f.location_id%TYPE
2826: ,p_organization_id IN per_assignments_f.organization_id%TYPE
2827: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
2828: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
2829: ,p_msl_personnel_office_id IN VARCHAR2
2830: ,p_msl_agency_code_subelement IN VARCHAR2
2831: ,p_msl_user_table_id IN NUMBER
2832: ,p_rec_pp_prd IN pp_prd

Line 2839: ,p_duty_station_id OUT NOCOPY ghr_duty_stations_f.duty_station_id%TYPE

2835: ,p_position_title OUT NOCOPY VARCHAR2
2836: ,p_position_number OUT NOCOPY VARCHAR2
2837: ,p_position_seq_no OUT NOCOPY VARCHAR2
2838: ,p_subelem_code OUT NOCOPY VARCHAR2
2839: ,p_duty_station_id OUT NOCOPY ghr_duty_stations_f.duty_station_id%TYPE
2840: ,p_tenure OUT NOCOPY VARCHAR2
2841: ,p_annuitant_indicator OUT NOCOPY VARCHAR2
2842: ,p_pay_rate_determinant OUT NOCOPY VARCHAR2
2843: ,p_work_schedule OUT NOCOPY VARCHAR2

Line 3197: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE

3193: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
3194: ,p_location_id IN per_assignments_f.location_id%TYPE
3195: ,p_organization_id IN per_assignments_f.organization_id%TYPE
3196: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
3197: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
3198: ,p_msl_personnel_office_id IN VARCHAR2
3199: ,p_msl_agency_code_subelement IN VARCHAR2
3200: ,p_msl_user_table_id IN NUMBER
3201: ,p_rec_pp_prd_per_gr IN pp_prd_per_gr

Line 3208: ,p_duty_station_id OUT NOCOPY ghr_duty_stations_f.duty_station_id%TYPE

3204: ,p_position_title OUT NOCOPY VARCHAR2
3205: ,p_position_number OUT NOCOPY VARCHAR2
3206: ,p_position_seq_no OUT NOCOPY VARCHAR2
3207: ,p_subelem_code OUT NOCOPY VARCHAR2
3208: ,p_duty_station_id OUT NOCOPY ghr_duty_stations_f.duty_station_id%TYPE
3209: ,p_tenure OUT NOCOPY VARCHAR2
3210: ,p_annuitant_indicator OUT NOCOPY VARCHAR2
3211: ,p_pay_rate_determinant OUT NOCOPY VARCHAR2
3212: ,p_work_schedule OUT NOCOPY VARCHAR2

Line 3543: FROM ghr_duty_stations_f

3539:
3540: CURSOR cur_valid_DS(p_ds_id NUMBER)
3541: IS
3542: SELECT effective_end_date end_date
3543: FROM ghr_duty_stations_f
3544: WHERE duty_station_id=p_ds_id
3545: AND g_effective_date between effective_start_date and effective_end_date;
3546:
3547: l_ds_end_date ghr_duty_stations_f.effective_end_date%type;

Line 3547: l_ds_end_date ghr_duty_stations_f.effective_end_date%type;

3543: FROM ghr_duty_stations_f
3544: WHERE duty_station_id=p_ds_id
3545: AND g_effective_date between effective_start_date and effective_end_date;
3546:
3547: l_ds_end_date ghr_duty_stations_f.effective_end_date%type;
3548:
3549:
3550: l_proc varchar2(72) := g_package || '.check_init_eligibility';
3551: BEGIN

Line 5300: ,p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE

5296: ,p_position_title IN VARCHAR2
5297: ,p_position_number IN VARCHAR2
5298: ,p_position_seq_no IN VARCHAR2
5299: ,p_subelem_code IN VARCHAR2
5300: ,p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
5301: ,p_tenure IN VARCHAR2
5302: ,p_annuitant_indicator IN VARCHAR2
5303: ,p_pay_rate_determinant IN VARCHAR2
5304: ,p_work_schedule IN VARCHAR2

Line 5318: FROM ghr_duty_stations_f

5314: -- Bug3437354
5315: CURSOR cur_valid_DS(p_ds_id NUMBER)
5316: IS
5317: SELECT effective_end_date end_date
5318: FROM ghr_duty_stations_f
5319: WHERE duty_station_id=p_ds_id
5320: AND g_effective_date between effective_start_date and effective_end_date;
5321: --7577249
5322: cursor get_sal_chg_fam is

Line 5333: l_ds_end_date ghr_duty_stations_f.effective_end_date%type;

5329: from ghr_nature_of_actions
5330: where code = nvl(g_first_noa_code,'894') and g_effective_date between date_from and nvl(date_to,g_effective_date))
5331: ) and proc_method_flag = 'Y';
5332: --7577249
5333: l_ds_end_date ghr_duty_stations_f.effective_end_date%type;
5334:
5335: l_locality_adj number;
5336: l_multi_error_flag boolean;
5337:

Line 6725: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE

6721: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
6722: ,p_location_id IN per_assignments_f.location_id%TYPE
6723: ,p_organization_id IN per_assignments_f.organization_id%TYPE
6724: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
6725: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
6726: ,p_msl_personnel_office_id IN VARCHAR2
6727: ,p_msl_agency_code_subelement IN VARCHAR2
6728: ,p_msl_user_table_id IN NUMBER
6729: ,p_rec_pp_prd IN pp_prd

Line 6736: ,p_duty_station_id OUT NOCOPY ghr_duty_stations_f.duty_station_id%TYPE

6732: ,p_position_title OUT NOCOPY VARCHAR2
6733: ,p_position_number OUT NOCOPY VARCHAR2
6734: ,p_position_seq_no OUT NOCOPY VARCHAR2
6735: ,p_subelem_code OUT NOCOPY VARCHAR2
6736: ,p_duty_station_id OUT NOCOPY ghr_duty_stations_f.duty_station_id%TYPE
6737: ,p_tenure OUT NOCOPY VARCHAR2
6738: ,p_annuitant_indicator OUT NOCOPY VARCHAR2
6739: ,p_pay_rate_determinant OUT NOCOPY VARCHAR2
6740: ,p_work_schedule OUT NOCOPY VARCHAR2

Line 7432: ,p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE

7428: ,p_position_title IN VARCHAR2
7429: ,p_position_number IN VARCHAR2
7430: ,p_position_seq_no IN VARCHAR2
7431: ,p_subelem_code IN VARCHAR2
7432: ,p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
7433: ,p_tenure IN VARCHAR2
7434: ,p_annuitant_indicator IN VARCHAR2
7435: ,p_pay_rate_determinant IN VARCHAR2
7436: ,p_work_schedule IN VARCHAR2

Line 7451: FROM ghr_duty_stations_f

7447: -- Bug3437354
7448: CURSOR cur_valid_DS(p_ds_id NUMBER)
7449: IS
7450: SELECT effective_end_date end_date
7451: FROM ghr_duty_stations_f
7452: WHERE duty_station_id=p_ds_id
7453: AND g_effective_date between effective_start_date and effective_end_date;
7454:
7455: l_ds_end_date ghr_duty_stations_f.effective_end_date%type;

Line 7455: l_ds_end_date ghr_duty_stations_f.effective_end_date%type;

7451: FROM ghr_duty_stations_f
7452: WHERE duty_station_id=p_ds_id
7453: AND g_effective_date between effective_start_date and effective_end_date;
7454:
7455: l_ds_end_date ghr_duty_stations_f.effective_end_date%type;
7456:
7457: BEGIN
7458: savepoint execute_msl_sp;
7459: l_msl_cnt := l_msl_cnt +1;