DBA Data[Home] [Help]

APPS.PQH_SS_HISTORY dependencies on HR_API_TRANSACTIONS

Line 527: from hr_api_transactions

523: l_c1 varchar2(30);
524: --
525: cursor c_th_txn (c_txn_id in number) is
526: select *
527: from hr_api_transactions
528: where transaction_id = c_txn_id;
529: --
530: cursor c_th_txn_h (c_txn_id in number) is
531: select null

Line 765: from hr_api_transactions

761: and approval_history_id = 0;
762: --
763: cursor c_ov_txn (c_txn_id in number) is
764: select *
765: from hr_api_transactions
766: where transaction_id = c_txn_id;
767: --
768: cursor c_ov_txn_h (c_txn_id in number) is
769: select null

Line 970: from hr_api_transactions

966: OR api_name = c_api_name);
967: --
968: cursor c_vt_txn (c_txn_id in number) is
969: select *
970: from hr_api_transactions
971: where transaction_id = c_txn_id;
972: --
973: cursor c_vt_txn_h (c_txn_id in number) is
974: select null