APPS.GHR_MSL_PKG dependencies on GHR_DUTY_STATIONS_F

Line 391: ,p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE

387: ,p_position_title IN VARCHAR2
388: ,p_position_number IN VARCHAR2
389: ,p_position_seq_no IN VARCHAR2
390: ,p_subelem_code IN VARCHAR2
391: ,p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
392: ,p_tenure IN VARCHAR2
393: ,p_annuitant_indicator IN VARCHAR2
394: ,p_pay_rate_determinant IN VARCHAR2
395: ,p_work_schedule IN VARCHAR2

Line 410: FROM ghr_duty_stations_f

406: -- Bug3437354
407: CURSOR cur_valid_DS(p_ds_id NUMBER)
408: IS
409: SELECT effective_end_date end_date
410: FROM ghr_duty_stations_f
411: WHERE duty_station_id=p_ds_id
412: AND g_effective_date between effective_start_date and effective_end_date;
413:
414: l_ds_end_date ghr_duty_stations_f.effective_end_date%type;

Line 414: l_ds_end_date ghr_duty_stations_f.effective_end_date%type;

410: FROM ghr_duty_stations_f
411: WHERE duty_station_id=p_ds_id
412: AND g_effective_date between effective_start_date and effective_end_date;
413:
414: l_ds_end_date ghr_duty_stations_f.effective_end_date%type;
415:
416: BEGIN
417: savepoint execute_msl_sp;
418: l_msl_cnt := l_msl_cnt +1;

Line 2798: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE

2794: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
2795: ,p_location_id IN per_assignments_f.location_id%TYPE
2796: ,p_organization_id IN per_assignments_f.organization_id%TYPE
2797: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
2798: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
2799: ,p_msl_personnel_office_id IN VARCHAR2
2800: ,p_msl_agency_code_subelement IN VARCHAR2
2801: ,p_msl_user_table_id IN NUMBER
2802: ,p_rec_pp_prd IN pp_prd

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

2805: ,p_position_title OUT NOCOPY VARCHAR2
2806: ,p_position_number OUT NOCOPY VARCHAR2
2807: ,p_position_seq_no OUT NOCOPY VARCHAR2
2808: ,p_subelem_code OUT NOCOPY VARCHAR2
2809: ,p_duty_station_id OUT NOCOPY ghr_duty_stations_f.duty_station_id%TYPE
2810: ,p_tenure OUT NOCOPY VARCHAR2
2811: ,p_annuitant_indicator OUT NOCOPY VARCHAR2
2812: ,p_pay_rate_determinant OUT NOCOPY VARCHAR2
2813: ,p_work_schedule OUT NOCOPY VARCHAR2

Line 3164: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE

3160: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
3161: ,p_location_id IN per_assignments_f.location_id%TYPE
3162: ,p_organization_id IN per_assignments_f.organization_id%TYPE
3163: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
3164: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
3165: ,p_msl_personnel_office_id IN VARCHAR2
3166: ,p_msl_agency_code_subelement IN VARCHAR2
3167: ,p_msl_user_table_id IN NUMBER
3168: ,p_rec_pp_prd_per_gr IN pp_prd_per_gr

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

3171: ,p_position_title OUT NOCOPY VARCHAR2
3172: ,p_position_number OUT NOCOPY VARCHAR2
3173: ,p_position_seq_no OUT NOCOPY VARCHAR2
3174: ,p_subelem_code OUT NOCOPY VARCHAR2
3175: ,p_duty_station_id OUT NOCOPY ghr_duty_stations_f.duty_station_id%TYPE
3176: ,p_tenure OUT NOCOPY VARCHAR2
3177: ,p_annuitant_indicator OUT NOCOPY VARCHAR2
3178: ,p_pay_rate_determinant OUT NOCOPY VARCHAR2
3179: ,p_work_schedule OUT NOCOPY VARCHAR2

Line 3509: FROM ghr_duty_stations_f

3505:
3506: CURSOR cur_valid_DS(p_ds_id NUMBER)
3507: IS
3508: SELECT effective_end_date end_date
3509: FROM ghr_duty_stations_f
3510: WHERE duty_station_id=p_ds_id
3511: AND g_effective_date between effective_start_date and effective_end_date;
3512:
3513: l_ds_end_date ghr_duty_stations_f.effective_end_date%type;

Line 3513: l_ds_end_date ghr_duty_stations_f.effective_end_date%type;

3509: FROM ghr_duty_stations_f
3510: WHERE duty_station_id=p_ds_id
3511: AND g_effective_date between effective_start_date and effective_end_date;
3512:
3513: l_ds_end_date ghr_duty_stations_f.effective_end_date%type;
3514:
3515:
3516: l_proc varchar2(72) := g_package || '.check_init_eligibility';
3517: BEGIN

Line 5236: ,p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE

5232: ,p_position_title IN VARCHAR2
5233: ,p_position_number IN VARCHAR2
5234: ,p_position_seq_no IN VARCHAR2
5235: ,p_subelem_code IN VARCHAR2
5236: ,p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
5237: ,p_tenure IN VARCHAR2
5238: ,p_annuitant_indicator IN VARCHAR2
5239: ,p_pay_rate_determinant IN VARCHAR2
5240: ,p_work_schedule IN VARCHAR2

Line 5254: FROM ghr_duty_stations_f

5250: -- Bug3437354
5251: CURSOR cur_valid_DS(p_ds_id NUMBER)
5252: IS
5253: SELECT effective_end_date end_date
5254: FROM ghr_duty_stations_f
5255: WHERE duty_station_id=p_ds_id
5256: AND g_effective_date between effective_start_date and effective_end_date;
5257: --7577249
5258: cursor get_sal_chg_fam is

Line 5269: l_ds_end_date ghr_duty_stations_f.effective_end_date%type;

5265: from ghr_nature_of_actions
5266: where code = nvl(g_first_noa_code,'894') and g_effective_date between date_from and nvl(date_to,g_effective_date))
5267: ) and proc_method_flag = 'Y';
5268: --7577249
5269: l_ds_end_date ghr_duty_stations_f.effective_end_date%type;
5270:
5271: BEGIN
5272: savepoint execute_msl_perc_sp;
5273: l_msl_cnt := l_msl_cnt +1;

Line 6584: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE

6580: ,p_business_group_id IN per_assignments_f.business_group_iD%TYPE
6581: ,p_location_id IN per_assignments_f.location_id%TYPE
6582: ,p_organization_id IN per_assignments_f.organization_id%TYPE
6583: ,p_msl_organization_id IN per_assignments_f.organization_id%TYPE
6584: ,p_msl_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
6585: ,p_msl_personnel_office_id IN VARCHAR2
6586: ,p_msl_agency_code_subelement IN VARCHAR2
6587: ,p_msl_user_table_id IN NUMBER
6588: ,p_rec_pp_prd IN pp_prd

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

6591: ,p_position_title OUT NOCOPY VARCHAR2
6592: ,p_position_number OUT NOCOPY VARCHAR2
6593: ,p_position_seq_no OUT NOCOPY VARCHAR2
6594: ,p_subelem_code OUT NOCOPY VARCHAR2
6595: ,p_duty_station_id OUT NOCOPY ghr_duty_stations_f.duty_station_id%TYPE
6596: ,p_tenure OUT NOCOPY VARCHAR2
6597: ,p_annuitant_indicator OUT NOCOPY VARCHAR2
6598: ,p_pay_rate_determinant OUT NOCOPY VARCHAR2
6599: ,p_work_schedule OUT NOCOPY VARCHAR2

Line 7284: ,p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE

7280: ,p_position_title IN VARCHAR2
7281: ,p_position_number IN VARCHAR2
7282: ,p_position_seq_no IN VARCHAR2
7283: ,p_subelem_code IN VARCHAR2
7284: ,p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
7285: ,p_tenure IN VARCHAR2
7286: ,p_annuitant_indicator IN VARCHAR2
7287: ,p_pay_rate_determinant IN VARCHAR2
7288: ,p_work_schedule IN VARCHAR2

Line 7303: FROM ghr_duty_stations_f

7299: -- Bug3437354
7300: CURSOR cur_valid_DS(p_ds_id NUMBER)
7301: IS
7302: SELECT effective_end_date end_date
7303: FROM ghr_duty_stations_f
7304: WHERE duty_station_id=p_ds_id
7305: AND g_effective_date between effective_start_date and effective_end_date;
7306:
7307: l_ds_end_date ghr_duty_stations_f.effective_end_date%type;

Line 7307: l_ds_end_date ghr_duty_stations_f.effective_end_date%type;

7303: FROM ghr_duty_stations_f
7304: WHERE duty_station_id=p_ds_id
7305: AND g_effective_date between effective_start_date and effective_end_date;
7306:
7307: l_ds_end_date ghr_duty_stations_f.effective_end_date%type;
7308:
7309: BEGIN
7310: savepoint execute_msl_sp;
7311: l_msl_cnt := l_msl_cnt +1;