DBA Data[Home] [Help]

APPS.HR_WORKFLOW_SS dependencies on PER_APPRAISALS

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

1696: into lv_transaction_ref_table,lv_transaction_ref_id
1697: from hr_api_transactions
1698: where hr_api_transactions.transaction_id=getApprStartingPointPersonId.p_transaction_id;
1699:
1700: if(lv_transaction_ref_table='PER_APPRAISALS') then
1701: begin
1702: select per_appraisals.main_appraiser_id
1703: into c_creator_person_id
1704: from per_appraisals

Line 1702: select per_appraisals.main_appraiser_id

1698: where hr_api_transactions.transaction_id=getApprStartingPointPersonId.p_transaction_id;
1699:
1700: if(lv_transaction_ref_table='PER_APPRAISALS') then
1701: begin
1702: select per_appraisals.main_appraiser_id
1703: into c_creator_person_id
1704: from per_appraisals
1705: where per_appraisals.appraisal_id=getApprStartingPointPersonId.lv_transaction_ref_id;
1706: exception

Line 1704: from per_appraisals

1700: if(lv_transaction_ref_table='PER_APPRAISALS') then
1701: begin
1702: select per_appraisals.main_appraiser_id
1703: into c_creator_person_id
1704: from per_appraisals
1705: where per_appraisals.appraisal_id=getApprStartingPointPersonId.lv_transaction_ref_id;
1706: exception
1707: when others then
1708: -- do not raise, return

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

1701: begin
1702: select per_appraisals.main_appraiser_id
1703: into c_creator_person_id
1704: from per_appraisals
1705: where per_appraisals.appraisal_id=getApprStartingPointPersonId.lv_transaction_ref_id;
1706: exception
1707: when others then
1708: -- do not raise, return
1709: null;