DBA Data[Home] [Help]

APPS.HR_SUPERVISOR_SS dependencies on HR_API_TRANSACTIONS

Line 132: AND not exists (select 'e' from hr_api_transaction_steps s, hr_api_transactions t

128: AND hao.organization_id = cost_center.organization_id
129: AND trunc(sysdate) between hao.date_from and nvl(hao.date_to,trunc(sysdate))
130: AND trunc(sysdate) between pap.effective_start_date and pap.effective_end_date
131: /* Excluding pending approvals */
132: AND not exists (select 'e' from hr_api_transaction_steps s, hr_api_transactions t
133: where s.api_name = 'HR_CCMGR_SS.PROCESS_API'
134: --Bug 3034218: Exclude current process, include v5 pending status RO, ROS and YS
135: and s.transaction_id = t.transaction_id and status IN ('YS', 'Y','RO','ROS')
136: and t.item_key <> itemKey

Line 885: ln_transaction_id hr_api_transactions.transaction_id%TYPE;

881:
882: IS
883:
884: ln_transaction_step_id NUMBER;
885: ln_transaction_id hr_api_transactions.transaction_id%TYPE;
886: ltt_trans_step_ids hr_util_web.g_varchar2_tab_type;
887: ltt_trans_obj_vers_num hr_util_web.g_varchar2_tab_type;
888: ln_trans_step_rows NUMBER ;
889: lv_activity_name wf_item_activity_statuses_v.activity_name%type ;