APPS.GHR_MTO_PKG dependencies on HR_GENERAL

Line 1012: HR_GENERAL.DECODE_LOOKUP('GHR_US_AGENCY_CODE_2',substr(l_agency_code,1,2)), --AVR

1008: l_org_func_code,
1009: l_appropriation_code1,
1010: l_appropriation_code2,
1011: l_position_organization,
1012: HR_GENERAL.DECODE_LOOKUP('GHR_US_AGENCY_CODE_2',substr(l_agency_code,1,2)), --AVR
1013: l_agency_code, -- p_to_position_org_line1 -- AVR
1014: ------- l_agency_code, -- p_first_noa_information1 (in earlier version)
1015: l_lac_sf52_rec,
1016: l_sf52_rec);

Line 1198: IF ( HR_GENERAL.DECODE_AVAILABILITY_STATUS(l_avail_status_id)

1194: l_effective_date)
1195: LOOP
1196: l_avail_status_id := per.availability_status_id;
1197:
1198: IF ( HR_GENERAL.DECODE_AVAILABILITY_STATUS(l_avail_status_id)
1199: not in ('Eliminated','Frozen','Deleted') ) THEN
1200:
1201: l_position_id := per.position_id;
1202: l_grade_id := per.grade_id;

Line 1352: IF ( HR_GENERAL.DECODE_AVAILABILITY_STATUS(l_avail_status_id)

1348: l_effective_date)
1349: LOOP
1350: -- Bug#4201666 Added the check to Restrict Eliminated, Frozen, Deleted Positions.
1351: l_avail_status_id := per_vacant.availability_status_id;
1352: IF ( HR_GENERAL.DECODE_AVAILABILITY_STATUS(l_avail_status_id)
1353: not in ('Eliminated','Frozen','Deleted') ) THEN
1354:
1355: IF check_select_flg(per_vacant.position_id,upper(p_action),
1356: l_effective_date,