APPS.PQH_LENGTH_OF_SERVICE_PKG dependencies on PER_ALL_PEOPLE_F

Line 20: p_person_id IN per_all_people_f.person_id%TYPE,

16: --
17: -- Length of service calculation for German PS
18: --
19: FUNCTION get_length_of_service( p_bg_id IN per_all_organization_units.organization_id%TYPE,
20: p_person_id IN per_all_people_f.person_id%TYPE,
21: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL,
22: p_prev_job_id IN per_previous_jobs.previous_job_id%TYPE DEFAULT NULL,
23: p_los_type IN VARCHAR2,
24: p_assg_start_date IN DATE ,

Line 30: p_person_id IN per_all_people_f.person_id%TYPE,

26: )
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;

Line 36: FUNCTION get_de_correction_factor(p_person_id IN per_all_people_f.person_id%TYPE,

32: p_start_date IN DATE,
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:

Line 41: FUNCTION get_length_previous_employment(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,
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;

Line 46: FUNCTION get_correction_factor ( 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,
48: p_effective_date IN DATE)
49: RETURN NUMBER;
50:

Line 73: FUNCTION get_employee_type (p_person_id IN per_all_people_f.person_id%TYPE,

69: p_bg_frequency IN VARCHAR2,
70: p_asg_hours IN NUMBER,
71: p_asg_frequency IN VARCHAR2)
72: RETURN NUMBER;
73: FUNCTION get_employee_type (p_person_id IN per_all_people_f.person_id%TYPE,
74: p_determination_date IN DATE)
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,

Line 77: p_person_id IN per_all_people_f.person_id%TYPE,

73: FUNCTION get_employee_type (p_person_id IN per_all_people_f.person_id%TYPE,
74: p_determination_date IN DATE)
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