eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_MISC_WEB dependencies on PER_ASSIGNMENTS_F

Line 58: assignment_id per_assignments_f.assignment_id%TYPE,

54: actid NUMBER
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,

Line 67: assignment_number per_assignments_f.assignment_number%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,
71: payroll_id per_assignments_f.payroll_id%TYPE,

Line 68: business_group_id per_assignments_f.business_group_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,
71: payroll_id per_assignments_f.payroll_id%TYPE,
72: location_id per_assignments_f.location_id%TYPE,

Line 69: effective_start_date per_assignments_f.effective_start_date%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,
71: payroll_id per_assignments_f.payroll_id%TYPE,
72: location_id per_assignments_f.location_id%TYPE,
73: primary_flag per_assignments_f.primary_flag%TYPE,

Line 70: effective_end_date per_assignments_f.effective_end_date%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,
71: payroll_id per_assignments_f.payroll_id%TYPE,
72: location_id per_assignments_f.location_id%TYPE,
73: primary_flag per_assignments_f.primary_flag%TYPE,
74: object_version_number per_assignments_f.object_version_number%TYPE

Line 71: payroll_id per_assignments_f.payroll_id%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,
71: payroll_id per_assignments_f.payroll_id%TYPE,
72: location_id per_assignments_f.location_id%TYPE,
73: primary_flag per_assignments_f.primary_flag%TYPE,
74: object_version_number per_assignments_f.object_version_number%TYPE
75: );

Line 72: location_id per_assignments_f.location_id%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,
71: payroll_id per_assignments_f.payroll_id%TYPE,
72: location_id per_assignments_f.location_id%TYPE,
73: primary_flag per_assignments_f.primary_flag%TYPE,
74: object_version_number per_assignments_f.object_version_number%TYPE
75: );
76:

Line 73: primary_flag per_assignments_f.primary_flag%TYPE,

69: effective_start_date per_assignments_f.effective_start_date%TYPE,
70: effective_end_date per_assignments_f.effective_end_date%TYPE,
71: payroll_id per_assignments_f.payroll_id%TYPE,
72: location_id per_assignments_f.location_id%TYPE,
73: primary_flag per_assignments_f.primary_flag%TYPE,
74: object_version_number per_assignments_f.object_version_number%TYPE
75: );
76:
77:

Line 74: object_version_number per_assignments_f.object_version_number%TYPE

70: effective_end_date per_assignments_f.effective_end_date%TYPE,
71: payroll_id per_assignments_f.payroll_id%TYPE,
72: location_id per_assignments_f.location_id%TYPE,
73: primary_flag per_assignments_f.primary_flag%TYPE,
74: object_version_number per_assignments_f.object_version_number%TYPE
75: );
76:
77:
78: TYPE grt_person_details IS RECORD (

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

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

Line 468: p_assignment_id IN per_assignments_f.assignment_id%TYPE,

464: ||
465: ||===========================================================================
466: */
467: FUNCTION get_assignment_details (
468: p_assignment_id IN per_assignments_f.assignment_id%TYPE,
469: p_effective_date IN DATE
470: )
471: RETURN hr_misc_web.grt_assignment_details;
472: