DBA Data[Home] [Help]

APPS.HR_MISC_WEB dependencies on HR_ORGANIZATION_UNITS

Line 65: organization_id hr_organization_units.organization_id%TYPE,

61: supervisor_id per_people_f.person_id%TYPE,
62: supervisor_full_name per_people_f.full_name%TYPE,
63: job_id per_jobs.job_id%TYPE,
64: job_name per_jobs.name%TYPE,
65: organization_id hr_organization_units.organization_id%TYPE,
66: organization_name hr_organization_units.name%TYPE,
67: assignment_number per_assignments_f.assignment_number%TYPE,
68: business_group_id per_assignments_f.business_group_id%TYPE,
69: effective_start_date per_assignments_f.effective_start_date%TYPE,

Line 66: organization_name hr_organization_units.name%TYPE,

62: supervisor_full_name per_people_f.full_name%TYPE,
63: job_id per_jobs.job_id%TYPE,
64: job_name per_jobs.name%TYPE,
65: organization_id hr_organization_units.organization_id%TYPE,
66: organization_name hr_organization_units.name%TYPE,
67: assignment_number per_assignments_f.assignment_number%TYPE,
68: business_group_id per_assignments_f.business_group_id%TYPE,
69: effective_start_date per_assignments_f.effective_start_date%TYPE,
70: effective_end_date per_assignments_f.effective_end_date%TYPE,

Line 432: p_job_id IN hr_organization_units.organization_id%TYPE,

428:
429:
430: FUNCTION get_job_segments
431: ( p_bg_id IN per_all_people_f.business_group_id%TYPE,
432: p_job_id IN hr_organization_units.organization_id%TYPE,
433: p_job_name IN hr_organization_units.name%TYPE)
434: RETURN VARCHAR2;
435:
436:

Line 433: p_job_name IN hr_organization_units.name%TYPE)

429:
430: FUNCTION get_job_segments
431: ( p_bg_id IN per_all_people_f.business_group_id%TYPE,
432: p_job_id IN hr_organization_units.organization_id%TYPE,
433: p_job_name IN hr_organization_units.name%TYPE)
434: RETURN VARCHAR2;
435:
436:
437: