APPS.HR_MISC_WEB dependencies on PER_ASSIGNMENTS_F

Line 493: p_assignment_id IN per_assignments_f.assignment_id%TYPE,

489: ||
490: ||===========================================================================
491: */
492: FUNCTION get_assignment_details (
493: p_assignment_id IN per_assignments_f.assignment_id%TYPE,
494: p_effective_date IN DATE
495: )
496: RETURN hr_misc_web.grt_assignment_details
497: IS

Line 504: p_assignment_id IN per_assignments_f.assignment_id%TYPE,

500: lrt_assignment_details hr_misc_web.grt_assignment_details;
501: lrt_empty hr_misc_web.grt_assignment_details;
502:
503: CURSOR lc_assignment_details (
504: p_assignment_id IN per_assignments_f.assignment_id%TYPE,
505: p_effective_date IN DATE
506: ) IS
507: SELECT ppf.person_id,
508: ppf.full_name,

Line 542: p_assignment_id IN per_assignments_f.assignment_id%TYPE,

538: --
539: -- 1839081
540: --
541: CURSOR lc_supervisor_details (
542: p_assignment_id IN per_assignments_f.assignment_id%TYPE,
543: p_effective_date IN DATE
544: ) IS
545: SELECT ppf.person_id,
546: ppf.full_name

Line 563: p_assignment_id IN per_assignments_f.assignment_id%TYPE,

559: --
560: -- 1839081
561: --
562: CURSOR lc_job_details (
563: p_assignment_id IN per_assignments_f.assignment_id%TYPE,
564: p_effective_date IN DATE
565: ) IS
566: SELECT pj.job_id,
567: pj.name

Line 583: p_assignment_id IN per_assignments_f.assignment_id%TYPE,

579: --
580: -- 1839081
581: --
582: CURSOR lc_loc_details (
583: p_assignment_id IN per_assignments_f.assignment_id%TYPE,
584: p_effective_date IN DATE
585: ) IS
586: SELECT hl.location_id,
587: hl.location_code

Line 602: p_assignment_id IN per_assignments_f.assignment_id%TYPE,

598: --
599: -- 1839081
600: --
601: CURSOR lc_organization_details (
602: p_assignment_id IN per_assignments_f.assignment_id%TYPE,
603: p_effective_date IN DATE
604: ) IS
605: SELECT hou.organization_id,
606: hou.name

Line 1022: p_assignment_id IN per_assignments_f.assignment_id%TYPE DEFAULT NULL,

1018: ||===========================================================================
1019: */
1020: FUNCTION get_legislation_code (
1021: p_person_id IN per_people_f.person_id%TYPE DEFAULT NULL,
1022: p_assignment_id IN per_assignments_f.assignment_id%TYPE DEFAULT NULL,
1023: p_business_group_id IN per_business_groups.business_group_id%TYPE
1024: DEFAULT NULL,
1025: p_effective_date IN DATE DEFAULT SYSDATE
1026: )