DBA Data[Home] [Help]

APPS.HR_MISC_WEB dependencies on HR_ORGANIZATION_UNITS

Line 388: p_job_id IN hr_organization_units.organization_id%TYPE,

384:
385:
386: FUNCTION get_job_segments
387: ( p_bg_id IN per_all_people_f.business_group_id%TYPE,
388: p_job_id IN hr_organization_units.organization_id%TYPE,
389: p_job_name IN hr_organization_units.name%TYPE)
390: RETURN VARCHAR2
391: IS
392: sshr_segment VARCHAR2(500) DEFAULT NULL;

Line 389: p_job_name IN hr_organization_units.name%TYPE)

385:
386: FUNCTION get_job_segments
387: ( p_bg_id IN per_all_people_f.business_group_id%TYPE,
388: p_job_id IN hr_organization_units.organization_id%TYPE,
389: p_job_name IN hr_organization_units.name%TYPE)
390: RETURN VARCHAR2
391: IS
392: sshr_segment VARCHAR2(500) DEFAULT NULL;
393: job_segments VARCHAR2(500) DEFAULT '';

Line 607: FROM hr_organization_units hou,

603: p_effective_date IN DATE
604: ) IS
605: SELECT hou.organization_id,
606: hou.name
607: FROM hr_organization_units hou,
608: per_all_assignments_f paf
609: WHERE paf.assignment_id = p_assignment_id
610: AND paf.organization_id = hou.organization_id
611: -- AND paf.primary_flag = 'Y' -- To supprot multiple assignments