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 60: assignment_id per_all_assignments_f.assignment_id%TYPE,

56: person_id per_personal_scorecards.person_id%TYPE,
57: scorecard_name per_personal_scorecards.scorecard_name%TYPE);
58:
59: TYPE assignment_info is RECORD (
60: assignment_id per_all_assignments_f.assignment_id%TYPE,
61: business_group_id per_all_assignments_f.business_group_id%TYPE,
62: grade_id per_all_assignments_f.grade_id%TYPE,
63: position_id per_all_assignments_f.position_id%TYPE,
64: job_id per_all_assignments_f.job_id%TYPE,

Line 61: business_group_id per_all_assignments_f.business_group_id%TYPE,

57: scorecard_name per_personal_scorecards.scorecard_name%TYPE);
58:
59: TYPE assignment_info is RECORD (
60: assignment_id per_all_assignments_f.assignment_id%TYPE,
61: business_group_id per_all_assignments_f.business_group_id%TYPE,
62: grade_id per_all_assignments_f.grade_id%TYPE,
63: position_id per_all_assignments_f.position_id%TYPE,
64: job_id per_all_assignments_f.job_id%TYPE,
65: org_id per_all_assignments_f.organization_id%TYPE,

Line 62: grade_id per_all_assignments_f.grade_id%TYPE,

58:
59: TYPE assignment_info is RECORD (
60: assignment_id per_all_assignments_f.assignment_id%TYPE,
61: business_group_id per_all_assignments_f.business_group_id%TYPE,
62: grade_id per_all_assignments_f.grade_id%TYPE,
63: position_id per_all_assignments_f.position_id%TYPE,
64: job_id per_all_assignments_f.job_id%TYPE,
65: org_id per_all_assignments_f.organization_id%TYPE,
66: supervisor_id per_all_assignments_f.supervisor_id%TYPE,

Line 63: position_id per_all_assignments_f.position_id%TYPE,

59: TYPE assignment_info is RECORD (
60: assignment_id per_all_assignments_f.assignment_id%TYPE,
61: business_group_id per_all_assignments_f.business_group_id%TYPE,
62: grade_id per_all_assignments_f.grade_id%TYPE,
63: position_id per_all_assignments_f.position_id%TYPE,
64: job_id per_all_assignments_f.job_id%TYPE,
65: org_id per_all_assignments_f.organization_id%TYPE,
66: supervisor_id per_all_assignments_f.supervisor_id%TYPE,
67: effective_state_date per_all_assignments_f.effective_start_date%TYPE,

Line 64: job_id per_all_assignments_f.job_id%TYPE,

60: assignment_id per_all_assignments_f.assignment_id%TYPE,
61: business_group_id per_all_assignments_f.business_group_id%TYPE,
62: grade_id per_all_assignments_f.grade_id%TYPE,
63: position_id per_all_assignments_f.position_id%TYPE,
64: job_id per_all_assignments_f.job_id%TYPE,
65: org_id per_all_assignments_f.organization_id%TYPE,
66: supervisor_id per_all_assignments_f.supervisor_id%TYPE,
67: effective_state_date per_all_assignments_f.effective_start_date%TYPE,
68: empl_start_date per_all_people_f.effective_start_date%TYPE,

Line 65: org_id per_all_assignments_f.organization_id%TYPE,

61: business_group_id per_all_assignments_f.business_group_id%TYPE,
62: grade_id per_all_assignments_f.grade_id%TYPE,
63: position_id per_all_assignments_f.position_id%TYPE,
64: job_id per_all_assignments_f.job_id%TYPE,
65: org_id per_all_assignments_f.organization_id%TYPE,
66: supervisor_id per_all_assignments_f.supervisor_id%TYPE,
67: effective_state_date per_all_assignments_f.effective_start_date%TYPE,
68: empl_start_date per_all_people_f.effective_start_date%TYPE,
69: empl_end_date per_all_people_f.effective_end_date%TYPE,

Line 66: supervisor_id per_all_assignments_f.supervisor_id%TYPE,

62: grade_id per_all_assignments_f.grade_id%TYPE,
63: position_id per_all_assignments_f.position_id%TYPE,
64: job_id per_all_assignments_f.job_id%TYPE,
65: org_id per_all_assignments_f.organization_id%TYPE,
66: supervisor_id per_all_assignments_f.supervisor_id%TYPE,
67: effective_state_date per_all_assignments_f.effective_start_date%TYPE,
68: empl_start_date per_all_people_f.effective_start_date%TYPE,
69: empl_end_date per_all_people_f.effective_end_date%TYPE,
70: person_id per_all_people_f.person_id%TYPE

Line 67: effective_state_date per_all_assignments_f.effective_start_date%TYPE,

63: position_id per_all_assignments_f.position_id%TYPE,
64: job_id per_all_assignments_f.job_id%TYPE,
65: org_id per_all_assignments_f.organization_id%TYPE,
66: supervisor_id per_all_assignments_f.supervisor_id%TYPE,
67: effective_state_date per_all_assignments_f.effective_start_date%TYPE,
68: empl_start_date per_all_people_f.effective_start_date%TYPE,
69: empl_end_date per_all_people_f.effective_end_date%TYPE,
70: person_id per_all_people_f.person_id%TYPE
71: );

Line 792: cursor get_assignment_info(p_assignment_id per_all_assignments_f.assignment_id%TYPE)

788: IS
789: SELECT scorecard_id, assignment_id, person_id, scorecard_name FROM per_personal_scorecards
790: WHERE scorecard_id = p_scorecard_id;
791: --changed cursor for fixing 6924829
792: cursor get_assignment_info(p_assignment_id per_all_assignments_f.assignment_id%TYPE)
793: IS
794: SELECT paf.assignment_id, paf.business_group_id, paf.grade_id, paf.position_id,
795: paf.job_id,
796: paf.organization_id, paf.supervisor_id, paf.effective_start_date,

Line 799: FROM per_all_assignments_f paf, per_all_people_f ppf, per_periods_of_service

795: paf.job_id,
796: paf.organization_id, paf.supervisor_id, paf.effective_start_date,
797: pps.date_start empl_start_date,
798: ppf.effective_end_date empl_end_date, ppf.person_id
799: FROM per_all_assignments_f paf, per_all_people_f ppf, per_periods_of_service
800: pps
801: WHERE paf.assignment_id = p_assignment_id
802: and trunc(sysdate) between paf.effective_start_date and
803: paf.effective_end_date

Line 815: FROM per_all_assignments_f paf, per_all_people_f ppf,

811: paf.job_id,
812: paf.organization_id, paf.supervisor_id, paf.effective_start_date,
813: pps.date_start empl_start_date,
814: ppf.effective_end_date empl_end_date, ppf.person_id
815: FROM per_all_assignments_f paf, per_all_people_f ppf,
816: per_periods_of_placement pps
817: WHERE paf.assignment_id = p_assignment_id
818: and trunc(sysdate) between paf.effective_start_date and
819: paf.effective_end_date