DBA Data[Home] [Help]

APPS.HR_WORKFLOW_SS dependencies on PER_APPRAISALS

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

1738: into lv_transaction_ref_table,lv_transaction_ref_id
1739: from hr_api_transactions
1740: where hr_api_transactions.transaction_id=getApprStartingPointPersonId.p_transaction_id;
1741:
1742: if(lv_transaction_ref_table='PER_APPRAISALS') then
1743: begin
1744: select per_appraisals.main_appraiser_id
1745: into c_creator_person_id
1746: from per_appraisals

Line 1744: select per_appraisals.main_appraiser_id

1740: where hr_api_transactions.transaction_id=getApprStartingPointPersonId.p_transaction_id;
1741:
1742: if(lv_transaction_ref_table='PER_APPRAISALS') then
1743: begin
1744: select per_appraisals.main_appraiser_id
1745: into c_creator_person_id
1746: from per_appraisals
1747: where per_appraisals.appraisal_id=getApprStartingPointPersonId.lv_transaction_ref_id;
1748: exception

Line 1746: from per_appraisals

1742: if(lv_transaction_ref_table='PER_APPRAISALS') then
1743: begin
1744: select per_appraisals.main_appraiser_id
1745: into c_creator_person_id
1746: from per_appraisals
1747: where per_appraisals.appraisal_id=getApprStartingPointPersonId.lv_transaction_ref_id;
1748: exception
1749: when others then
1750: -- do not raise, return

Line 1747: where per_appraisals.appraisal_id=getApprStartingPointPersonId.lv_transaction_ref_id;

1743: begin
1744: select per_appraisals.main_appraiser_id
1745: into c_creator_person_id
1746: from per_appraisals
1747: where per_appraisals.appraisal_id=getApprStartingPointPersonId.lv_transaction_ref_id;
1748: exception
1749: when others then
1750: -- do not raise, return
1751: null;