DBA Data[Home] [Help]

APPS.PERFRPHR dependencies on PER_APPLICATIONS

Line 224: FROM per_applications

220: WHERE period_of_service_id = b_period_id;
221: --
222: CURSOR c_appl_date (b_appl_id IN NUMBER) IS
223: SELECT projected_hire_date
224: FROM per_applications
225: WHERE application_id = b_appl_id;
226: --
227: CURSOR c_urssaf_code (b_est_id IN NUMBER) IS
228: SELECT UPPER(hoi2.org_information1)