APPS.HR_WPM_MASS_APR_PUSH dependencies on HR_API_TRANSACTIONS

Line 1446: FROM hr_api_transactions t

1442: CURSOR csr_pend_trans(p_plan_id IN NUMBER) IS
1443: SELECT 'x'
1444: FROM DUAL
1445: WHERE EXISTS (SELECT 'x'
1446: FROM hr_api_transactions t
1447: ,per_personal_scorecards sc
1448: WHERE t.transaction_ref_table = 'PER_PERSONAL_SCORECARDS'
1449: AND t.transaction_ref_id = sc.scorecard_id
1450: AND sc.plan_id = p_plan_id);

Line 1577: FROM hr_api_transactions

1573: --
1574: CURSOR c_trx (p_sc_card_id number)
1575: is
1576: SELECT transaction_id
1577: FROM hr_api_transactions
1578: WHERE transaction_ref_table = 'PER_PERSONAL_SCORECARDS'
1579: AND transaction_ref_id = p_sc_card_id;
1580: l_sc_ovn number;
1581: l_trx_id number;

Line 1680: delete from hr_api_transactions

1676: null;
1677: end;
1678: --
1679: begin
1680: delete from hr_api_transactions
1681: where transaction_id = l_trx_id;
1682: exception
1683: when others then
1684: null;