APPS.HR_WPM_MASS_APR_PUSH dependencies on HR_API

Line 2230: FROM hr_api_transactions t, per_personal_scorecards sc

2226: SELECT 'x'
2227: FROM DUAL
2228: WHERE EXISTS (
2229: SELECT 'x'
2230: FROM hr_api_transactions t, per_personal_scorecards sc
2231: WHERE t.transaction_ref_table = 'PER_PERSONAL_SCORECARDS'
2232: AND t.transaction_ref_id = sc.scorecard_id
2233: AND sc.plan_id = p_plan_id);
2234:

Line 2446: FROM hr_api_transactions

2442: --
2443: CURSOR c_trx (p_sc_card_id NUMBER)
2444: IS
2445: SELECT transaction_id
2446: FROM hr_api_transactions
2447: WHERE transaction_ref_table = 'PER_PERSONAL_SCORECARDS'
2448: AND transaction_ref_id = p_sc_card_id;
2449:
2450: l_sc_ovn NUMBER;

Line 2779: DELETE FROM hr_api_transaction_steps

2775:
2776: IF l_trx_id IS NOT NULL
2777: THEN
2778: BEGIN
2779: DELETE FROM hr_api_transaction_steps
2780: WHERE transaction_id = l_trx_id;
2781: EXCEPTION
2782: WHEN OTHERS
2783: THEN

Line 2789: DELETE FROM hr_api_transactions

2785: END;
2786:
2787: --
2788: BEGIN
2789: DELETE FROM hr_api_transactions
2790: WHERE transaction_id = l_trx_id;
2791: EXCEPTION
2792: WHEN OTHERS
2793: THEN

Line 3142: FROM hr_api_transactions

3138:
3139: CURSOR get_wf_details (p_appraisal_id IN NUMBER)
3140: IS
3141: SELECT item_type, item_key
3142: FROM hr_api_transactions
3143: WHERE transaction_ref_table = 'PER_APPRAISALS'
3144: AND transaction_ref_id = p_appraisal_id;
3145:
3146: CURSOR get_instance_label (p_block_activity_id IN NUMBER)