DBA Data[Home] [Help]

APPS.PQH_LENGTH_OF_SERVICE_PKG dependencies on PER_PREVIOUS_JOBS

Line 22: p_prev_job_id IN per_previous_jobs.previous_job_id%TYPE DEFAULT NULL,

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

Line 44: p_previous_job_id IN per_previous_jobs.previous_job_id%TYPE)

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,
48: p_effective_date IN DATE)