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 1327: if(lv_transaction_ref_table='PER_APPRAISALS') then

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

Line 1329: select per_appraisals.system_type

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

Line 1331: from per_appraisals

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

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

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

Line 1384: from per_appraisals appr, per_rating_levels prl

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