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_WPM_MASS_APR_PUSH dependencies on PER_ALL_ASSIGNMENTS_F

Line 71: assignment_id per_all_assignments_f.assignment_id%TYPE,

67: scorecard_name per_personal_scorecards.scorecard_name%TYPE
68: );
69:
70: TYPE assignment_info IS RECORD (
71: assignment_id per_all_assignments_f.assignment_id%TYPE,
72: business_group_id per_all_assignments_f.business_group_id%TYPE,
73: grade_id per_all_assignments_f.grade_id%TYPE,
74: position_id per_all_assignments_f.position_id%TYPE,
75: job_id per_all_assignments_f.job_id%TYPE,

Line 72: business_group_id per_all_assignments_f.business_group_id%TYPE,

68: );
69:
70: TYPE assignment_info IS RECORD (
71: assignment_id per_all_assignments_f.assignment_id%TYPE,
72: business_group_id per_all_assignments_f.business_group_id%TYPE,
73: grade_id per_all_assignments_f.grade_id%TYPE,
74: position_id per_all_assignments_f.position_id%TYPE,
75: job_id per_all_assignments_f.job_id%TYPE,
76: org_id per_all_assignments_f.organization_id%TYPE,

Line 73: grade_id per_all_assignments_f.grade_id%TYPE,

69:
70: TYPE assignment_info IS RECORD (
71: assignment_id per_all_assignments_f.assignment_id%TYPE,
72: business_group_id per_all_assignments_f.business_group_id%TYPE,
73: grade_id per_all_assignments_f.grade_id%TYPE,
74: position_id per_all_assignments_f.position_id%TYPE,
75: job_id per_all_assignments_f.job_id%TYPE,
76: org_id per_all_assignments_f.organization_id%TYPE,
77: supervisor_id per_all_assignments_f.supervisor_id%TYPE,

Line 74: position_id per_all_assignments_f.position_id%TYPE,

70: TYPE assignment_info IS RECORD (
71: assignment_id per_all_assignments_f.assignment_id%TYPE,
72: business_group_id per_all_assignments_f.business_group_id%TYPE,
73: grade_id per_all_assignments_f.grade_id%TYPE,
74: position_id per_all_assignments_f.position_id%TYPE,
75: job_id per_all_assignments_f.job_id%TYPE,
76: org_id per_all_assignments_f.organization_id%TYPE,
77: supervisor_id per_all_assignments_f.supervisor_id%TYPE,
78: effective_state_date per_all_assignments_f.effective_start_date%TYPE,

Line 75: job_id per_all_assignments_f.job_id%TYPE,

71: assignment_id per_all_assignments_f.assignment_id%TYPE,
72: business_group_id per_all_assignments_f.business_group_id%TYPE,
73: grade_id per_all_assignments_f.grade_id%TYPE,
74: position_id per_all_assignments_f.position_id%TYPE,
75: job_id per_all_assignments_f.job_id%TYPE,
76: org_id per_all_assignments_f.organization_id%TYPE,
77: supervisor_id per_all_assignments_f.supervisor_id%TYPE,
78: effective_state_date per_all_assignments_f.effective_start_date%TYPE,
79: empl_start_date per_all_people_f.effective_start_date%TYPE,

Line 76: org_id per_all_assignments_f.organization_id%TYPE,

72: business_group_id per_all_assignments_f.business_group_id%TYPE,
73: grade_id per_all_assignments_f.grade_id%TYPE,
74: position_id per_all_assignments_f.position_id%TYPE,
75: job_id per_all_assignments_f.job_id%TYPE,
76: org_id per_all_assignments_f.organization_id%TYPE,
77: supervisor_id per_all_assignments_f.supervisor_id%TYPE,
78: effective_state_date per_all_assignments_f.effective_start_date%TYPE,
79: empl_start_date per_all_people_f.effective_start_date%TYPE,
80: empl_end_date per_all_people_f.effective_end_date%TYPE,

Line 77: supervisor_id per_all_assignments_f.supervisor_id%TYPE,

73: grade_id per_all_assignments_f.grade_id%TYPE,
74: position_id per_all_assignments_f.position_id%TYPE,
75: job_id per_all_assignments_f.job_id%TYPE,
76: org_id per_all_assignments_f.organization_id%TYPE,
77: supervisor_id per_all_assignments_f.supervisor_id%TYPE,
78: effective_state_date per_all_assignments_f.effective_start_date%TYPE,
79: empl_start_date per_all_people_f.effective_start_date%TYPE,
80: empl_end_date per_all_people_f.effective_end_date%TYPE,
81: person_id per_all_people_f.person_id%TYPE

Line 78: effective_state_date per_all_assignments_f.effective_start_date%TYPE,

74: position_id per_all_assignments_f.position_id%TYPE,
75: job_id per_all_assignments_f.job_id%TYPE,
76: org_id per_all_assignments_f.organization_id%TYPE,
77: supervisor_id per_all_assignments_f.supervisor_id%TYPE,
78: effective_state_date per_all_assignments_f.effective_start_date%TYPE,
79: empl_start_date per_all_people_f.effective_start_date%TYPE,
80: empl_end_date per_all_people_f.effective_end_date%TYPE,
81: person_id per_all_people_f.person_id%TYPE
82: );

Line 1068: FROM per_all_assignments_f paf,

1064: paf.position_id, paf.job_id, paf.organization_id,
1065: paf.supervisor_id, paf.effective_start_date,
1066: pps.date_start empl_start_date,
1067: ppf.effective_end_date empl_end_date, ppf.person_id
1068: FROM per_all_assignments_f paf,
1069: per_all_people_f ppf,
1070: per_periods_of_service pps
1071: WHERE paf.person_id = p_person_id --8780710 bug fix
1072: AND TRUNC (SYSDATE) BETWEEN paf.effective_start_date

Line 1086: FROM per_all_assignments_f paf,

1082: paf.position_id, paf.job_id, paf.organization_id,
1083: paf.supervisor_id, paf.effective_start_date,
1084: pps.date_start empl_start_date,
1085: ppf.effective_end_date empl_end_date, ppf.person_id
1086: FROM per_all_assignments_f paf,
1087: per_all_people_f ppf,
1088: per_periods_of_placement pps
1089: WHERE paf.person_id = p_person_id --8780710 bug fix
1090: AND TRUNC (SYSDATE) BETWEEN paf.effective_start_date

Line 1184: FROM per_all_assignments_f

1180: p_person_id per_all_people_f.person_id%TYPE
1181: )
1182: IS
1183: SELECT DISTINCT (supervisor_id)
1184: FROM per_all_assignments_f
1185: WHERE person_id = p_person_id AND primary_flag <> 'Y';
1186:
1187: CURSOR find_appraisal (
1188: p_plan_id per_perf_mgmt_plans.plan_id%TYPE,