DBA Data[Home] [Help]

APPS.PQH_LENGTH_OF_SERVICE_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 623: FUNCTION get_military_service_period (p_bg_id IN hr_all_organization_units.organization_id%TYPE,

619: -- FUNCTION get_military_service_period
620: -- This function returns corrected number of days in Military Service for the
621: -- person as held in FR_PQH_BONIFICATION_DETAILS
622: -- -----------------------------------------------------------------------*
623: FUNCTION get_military_service_period (p_bg_id IN hr_all_organization_units.organization_id%TYPE,
624: p_person_id IN per_all_people_f.person_id%TYPE,
625: p_assignment_id IN per_assignments_f.assignment_id%TYPE,
626: p_los_type IN hr_lookups.lookup_code%TYPE,
627: p_start_date IN DATE,

Line 1467: FUNCTION get_de_military_service_period(p_bg_id IN hr_all_organization_units.organization_id%TYPE,

1463:
1464: --
1465: -- This Function returns the military service duration for an employee
1466: --
1467: FUNCTION get_de_military_service_period(p_bg_id IN hr_all_organization_units.organization_id%TYPE,
1468: p_person_id IN per_all_people_f.person_id%TYPE,
1469: p_los_type IN hr_lookups.lookup_code%TYPE,
1470: p_start_date IN DATE,
1471: p_end_date IN DATE)