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.PER_CAGR_UTILITY_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 1101: from per_all_assignments_f

1097: ,p_effective_date IN DATE) RETURN NUMBER IS
1098:
1099: CURSOR csr_get_cagr is
1100: select collective_agreement_id
1101: from per_all_assignments_f
1102: where assignment_id = p_assignment_id
1103: and p_effective_date between effective_start_date
1104: and nvl(effective_end_date,hr_general.end_of_time);
1105:

Line 1106: l_id per_all_assignments_f.collective_agreement_id%TYPE;

1102: where assignment_id = p_assignment_id
1103: and p_effective_date between effective_start_date
1104: and nvl(effective_end_date,hr_general.end_of_time);
1105:
1106: l_id per_all_assignments_f.collective_agreement_id%TYPE;
1107: BEGIN
1108:
1109: open csr_get_cagr;
1110: fetch csr_get_cagr into l_id;

Line 1140: ,per_all_assignments_f paaf

1136: ,psps.spinal_point_id
1137: ,psps.grade_spine_id
1138: from ben_pgm_f pgm
1139: ,per_grades_tl grdtl
1140: ,per_all_assignments_f paaf
1141: ,per_spinal_point_placements_f pspp
1142: ,per_spinal_point_steps_f psps
1143: where
1144: paaf.assignment_id = p_assignment_id