DBA Data[Home] [Help]

APPS.HR_MISC_WEB dependencies on PER_PEOPLE_F

Line 59: person_id per_people_f.person_id%TYPE,

55: );
56:
57: TYPE grt_assignment_details IS RECORD (
58: assignment_id per_assignments_f.assignment_id%TYPE,
59: person_id per_people_f.person_id%TYPE,
60: person_full_name per_people_f.full_name%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,

Line 60: person_full_name per_people_f.full_name%TYPE,

56:
57: TYPE grt_assignment_details IS RECORD (
58: assignment_id per_assignments_f.assignment_id%TYPE,
59: person_id per_people_f.person_id%TYPE,
60: person_full_name per_people_f.full_name%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,

Line 61: supervisor_id per_people_f.person_id%TYPE,

57: TYPE grt_assignment_details IS RECORD (
58: assignment_id per_assignments_f.assignment_id%TYPE,
59: person_id per_people_f.person_id%TYPE,
60: person_full_name per_people_f.full_name%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,

Line 62: supervisor_full_name per_people_f.full_name%TYPE,

58: assignment_id per_assignments_f.assignment_id%TYPE,
59: person_id per_people_f.person_id%TYPE,
60: person_full_name per_people_f.full_name%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,

Line 79: full_name per_people_f.full_name%TYPE,

75: );
76:
77:
78: TYPE grt_person_details IS RECORD (
79: full_name per_people_f.full_name%TYPE,
80: business_group_id per_people_f.business_group_id%TYPE
81: );
82:
83:

Line 80: business_group_id per_people_f.business_group_id%TYPE

76:
77:
78: TYPE grt_person_details IS RECORD (
79: full_name per_people_f.full_name%TYPE,
80: business_group_id per_people_f.business_group_id%TYPE
81: );
82:
83:
84: TYPE grt_enter_process_checks IS RECORD (

Line 237: p_person_id IN per_people_f.person_id%TYPE

233: ||
234: ||===========================================================================
235: */
236: FUNCTION get_business_group_id (
237: p_person_id IN per_people_f.person_id%TYPE
238: )
239: RETURN per_business_groups.business_group_id%TYPE;
240:
241: FUNCTION get_business_group_id

Line 279: p_person_id IN per_people_f.person_id%TYPE DEFAULT NULL,

275: ||
276: ||===========================================================================
277: */
278: FUNCTION get_legislation_code (
279: p_person_id IN per_people_f.person_id%TYPE DEFAULT NULL,
280: p_assignment_id IN per_assignments_f.assignment_id%TYPE DEFAULT NULL,
281: p_business_group_id IN per_business_groups.business_group_id%TYPE
282: DEFAULT NULL,
283: p_effective_date IN DATE DEFAULT SYSDATE

Line 317: p_person_id IN per_people_f.person_id%TYPE

313: ||
314: ||===========================================================================
315: */
316: FUNCTION get_person_details (
317: p_person_id IN per_people_f.person_id%TYPE
318: )
319: RETURN hr_misc_web.grt_person_details;
320:
321:

Line 504: p_person_id IN per_people_f.person_id%TYPE

500: ||
501: ||===========================================================================
502: */
503: FUNCTION get_assignment_id (
504: p_person_id IN per_people_f.person_id%TYPE
505: )
506: RETURN hr_misc_web.grt_assignment_details;
507:
508: /*