APPS.HR_AMEUTIL_SS dependencies on PER_APPRAISALS

Line 290: if(lv_transaction_ref_table='PER_APPRAISALS') then

286: into lv_transaction_ref_table,lv_transaction_ref_id
287: from hr_api_transactions
288: where transaction_id=p_transaction_id;
289:
290: if(lv_transaction_ref_table='PER_APPRAISALS') then
291: begin
292: select main_appraiser_id
293: into ln_requestor_person_id
294: from per_appraisals

Line 294: from per_appraisals

290: if(lv_transaction_ref_table='PER_APPRAISALS') then
291: begin
292: select main_appraiser_id
293: into ln_requestor_person_id
294: from per_appraisals
295: where appraisal_id=lv_transaction_ref_id;
296: exception
297: when others then
298: -- do not raise, return

Line 1325: if(lv_transaction_ref_table='PER_APPRAISALS') then

1321: into lv_transaction_ref_table,lv_transaction_ref_id
1322: from hr_api_transactions
1323: where transaction_id=p_transaction_id;
1324:
1325: if(lv_transaction_ref_table='PER_APPRAISALS') then
1326: begin
1327: select per_appraisals.system_type
1328: into lv_system_type
1329: from per_appraisals

Line 1327: select per_appraisals.system_type

1323: where transaction_id=p_transaction_id;
1324:
1325: if(lv_transaction_ref_table='PER_APPRAISALS') then
1326: begin
1327: select per_appraisals.system_type
1328: into lv_system_type
1329: from per_appraisals
1330: where appraisal_id=lv_transaction_ref_id;
1331: exception

Line 1329: from per_appraisals

1325: if(lv_transaction_ref_table='PER_APPRAISALS') then
1326: begin
1327: select per_appraisals.system_type
1328: into lv_system_type
1329: from per_appraisals
1330: where appraisal_id=lv_transaction_ref_id;
1331: exception
1332: when others then
1333: -- do not raise, return

Line 1378: if(lv_transaction_ref_table='PER_APPRAISALS') then

1374: into lv_transaction_ref_table,lv_transaction_ref_id
1375: from hr_api_transactions
1376: where transaction_id=p_transaction_id;
1377:
1378: if(lv_transaction_ref_table='PER_APPRAISALS') then
1379: begin
1380: Select prl.step_value
1381: into ln_overall_rating
1382: from per_appraisals appr, per_rating_levels prl

Line 1382: from per_appraisals appr, per_rating_levels prl

1378: if(lv_transaction_ref_table='PER_APPRAISALS') then
1379: begin
1380: Select prl.step_value
1381: into ln_overall_rating
1382: from per_appraisals appr, per_rating_levels prl
1383: where appraisal_id = lv_transaction_ref_id
1384: and appr.overall_performance_level_id = prl.rating_level_id;
1385: exception
1386: when others then