APPS.PQH_LENGTH_OF_SERVICE_PKG dependencies on HR_LOOKUPS

Line 31: p_los_type IN hr_lookups.lookup_code%TYPE,

27: RETURN VARCHAR2;
28:
29: FUNCTION get_de_military_service_period(p_bg_id IN hr_all_organization_units.organization_id%TYPE,
30: p_person_id IN per_all_people_f.person_id%TYPE,
31: p_los_type IN hr_lookups.lookup_code%TYPE,
32: p_start_date IN DATE,
33: p_end_date IN DATE)
34: RETURN VARCHAR2;
35:

Line 37: p_los_type IN hr_lookups.lookup_code%TYPE,

33: p_end_date IN DATE)
34: RETURN VARCHAR2;
35:
36: FUNCTION get_de_correction_factor(p_person_id IN per_all_people_f.person_id%TYPE,
37: p_los_type IN hr_lookups.lookup_code%TYPE,
38: p_effective_date IN DATE)
39: RETURN VARCHAR2;
40:
41: FUNCTION get_length_previous_employment(p_person_id IN per_all_people_f.person_id%TYPE,

Line 43: p_los_type IN hr_lookups.lookup_code%TYPE,

39: RETURN VARCHAR2;
40:
41: FUNCTION get_length_previous_employment(p_person_id IN per_all_people_f.person_id%TYPE,
42: p_bg_id IN per_all_organization_units.organization_id%TYPE,
43: p_los_type IN hr_lookups.lookup_code%TYPE,
44: p_previous_job_id IN per_previous_jobs.previous_job_id%TYPE)
45: RETURN NUMBER;
46: FUNCTION get_correction_factor ( p_person_id IN per_all_people_f.person_id%TYPE,
47: p_los_type IN hr_lookups.lookup_code%TYPE,

Line 47: p_los_type IN hr_lookups.lookup_code%TYPE,

43: p_los_type IN hr_lookups.lookup_code%TYPE,
44: p_previous_job_id IN per_previous_jobs.previous_job_id%TYPE)
45: RETURN NUMBER;
46: FUNCTION get_correction_factor ( p_person_id IN per_all_people_f.person_id%TYPE,
47: p_los_type IN hr_lookups.lookup_code%TYPE,
48: p_effective_date IN DATE)
49: RETURN NUMBER;
50:
51:

Line 79: p_los_type IN hr_lookups.lookup_code%TYPE,

75: RETURN VARCHAR2;
76: FUNCTION get_absent_period (p_bg_id IN per_all_organization_units.organization_id%TYPE,
77: p_person_id IN per_all_people_f.person_id%TYPE,
78: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
79: p_los_type IN hr_lookups.lookup_code%TYPE,
80: p_start_date IN DATE,
81: p_end_date IN DATE
82: )
83: RETURN NUMBER;

Line 87: p_los_type IN hr_lookups.lookup_code%TYPE,

83: RETURN NUMBER;
84: FUNCTION get_parttime_entitlement(p_person_id IN per_all_assignments_f.person_id%TYPE,
85: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
86: p_bg_id IN per_all_organization_units.organization_id%TYPE,
87: p_los_type IN hr_lookups.lookup_code%TYPE,
88: p_start_date IN DATE,
89: p_end_date IN DATE)
90:
91: RETURN NUMBER ;