DBA Data[Home] [Help]

APPS.PQH_LENGTH_OF_SERVICE_PKG dependencies on PER_ALL_ORGANIZATION_UNITS

Line 19: FUNCTION get_length_of_service( p_bg_id IN per_all_organization_units.organization_id%TYPE,

15: RETURN NUMBER;
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,

Line 42: p_bg_id IN per_all_organization_units.organization_id%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;
46: FUNCTION get_correction_factor ( p_person_id IN per_all_people_f.person_id%TYPE,

Line 53: p_bg_id IN per_all_organization_units.organization_id%TYPE)

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)
57: RETURN VARCHAR2;

Line 76: FUNCTION get_absent_period (p_bg_id IN per_all_organization_units.organization_id%TYPE,

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,
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,

Line 86: p_bg_id IN per_all_organization_units.organization_id%TYPE,

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)
90: