APPS.PAY_BEE_SS dependencies on HR_API_TRANSACTIONS

Line 1559: --from hr_api_transactions

1555: and varchar2_value = p_batch_name);
1556:
1557:
1558: --select CREATOR_PERSON_ID into p_login_person_id
1559: --from hr_api_transactions
1560: --where transaction_id=l_old_transaction_id;
1561:
1562:
1563: -- -- -- bee_trace('item key==' ||p_item_key);

Line 1703: from hr_api_transactions

1699: where name = 'P_BUSINESS_GROUP_ID'
1700: and transaction_step_id in (select transaction_step_id from hr_api_transaction_steps where transaction_id=l_transaction_id);
1701:
1702: select status into l_status_wf
1703: from hr_api_transactions
1704: where transaction_id=l_transaction_id;
1705:
1706: -- bee_trace('Batch name is '||l_batch_name);
1707: select created_by into l_user_id

Line 1708: from hr_api_transactions

1704: where transaction_id=l_transaction_id;
1705:
1706: -- bee_trace('Batch name is '||l_batch_name);
1707: select created_by into l_user_id
1708: from hr_api_transactions
1709: where transaction_id=l_transaction_id;
1710: select responsibility_id into l_resp_id from fnd_user_resp_groups_direct where user_id=l_user_id and rownum=1;
1711: --bee_trace('l_resp_id is '||l_resp_id);
1712: if (FND_GLOBAL.resp_id= -1) then

Line 1846: delete from hr_api_transactions

1842: delete from hr_api_transaction_steps
1843: where transaction_id=l_transaction_id;
1844:
1845: -- bee_trace('deleted from hr_api_transaction_steps');
1846: delete from hr_api_transactions
1847: where transaction_id=l_transaction_id;
1848:
1849: -- bee_trace('deleted from hr_api_transactions');
1850: end if;

Line 1849: -- bee_trace('deleted from hr_api_transactions');

1845: -- bee_trace('deleted from hr_api_transaction_steps');
1846: delete from hr_api_transactions
1847: where transaction_id=l_transaction_id;
1848:
1849: -- bee_trace('deleted from hr_api_transactions');
1850: end if;
1851:
1852:
1853: end delete_batch_on_cancel;