DBA Data[Home] [Help]

APPS.HR_COMPLETE_APPRAISAL_SS dependencies on HR_API

Line 2657: FROM hr_api_transactions

2653: WHERE pa.appraisal_id = l_appraisal_id;
2654: --10060770
2655: SELECT transaction_id
2656: INTO l_source_pk1_value
2657: FROM hr_api_transactions
2658: WHERE transaction_ref_table = 'PER_APPRAISALS' AND transaction_ref_id = l_appraisal_id
2659: AND item_type = COMPLETE_APPR.item_type
2660: AND item_key = complete_appr.item_key;
2661: