APPS.PQH_LENGTH_OF_SERVICE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 21: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL,

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 ,
25: p_assg_end_date IN DATE

Line 52: FUNCTION get_corps_name (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

48: p_effective_date IN DATE)
49: RETURN NUMBER;
50:
51:
52: FUNCTION get_corps_name (p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
53: p_bg_id IN per_all_organization_units.organization_id%TYPE)
54: RETURN VARCHAR2;
55:
56: FUNCTION get_corps_name (p_corps_id IN pqh_corps_definitions.corps_definition_id%TYPE)

Line 78: p_assignment_id IN per_all_assignments_f.assignment_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
82: )

Line 84: FUNCTION get_parttime_entitlement(p_person_id IN per_all_assignments_f.person_id%TYPE,

80: p_start_date IN DATE,
81: p_end_date IN DATE
82: )
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,

Line 85: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

81: p_end_date IN DATE
82: )
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)