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.PAY_ES_CALC_SS_EARNINGS dependencies on PER_ALL_PEOPLE_F

Line 108: FROM per_all_people_f papf

104: ,p_date_earned IN DATE) RETURN VARCHAR2 IS
105: --
106: CURSOR csr_get_emp_gender IS
107: SELECT papf.sex
108: FROM per_all_people_f papf
109: ,per_all_assignments_f paaf
110: WHERE paaf.assignment_id = p_assignment_id
111: AND papf.person_id = paaf.person_id
112: AND p_date_earned BETWEEN paaf.effective_start_date

Line 118: l_Gender per_all_people_f.sex%TYPE;

114: AND p_date_earned BETWEEN papf.effective_start_date
115: AND papf.effective_end_date;
116:
117: --
118: l_Gender per_all_people_f.sex%TYPE;
119: --
120: BEGIN
121: --
122: OPEN csr_get_emp_gender;