APPS.HR_UTIL_MISC_SS dependencies on HR_API_TRANSACTION_STEPS

Line 1701: , hr_api_transaction_steps hats

1697: SELECT hat.SELECTED_PERSON_ID, hatv2.number_value irc_doc_id
1698: INTO l_person_id,l_irc_doc_id
1699: FROM hr_api_transactions hat
1700: , fnd_attached_documents fads
1701: , hr_api_transaction_steps hats
1702: , hr_api_transaction_values hatv1
1703: , hr_api_transaction_values hatv2
1704: WHERE hat.transaction_id = l_source_pk1_value
1705: AND hats.transaction_id = hat.transaction_id

Line 1889: from hr_api_transaction_steps

1885: /*Added following variables as a part of ER#9879782 Ends*/
1886:
1887: cursor csr_hat_steps is
1888: select *
1889: from hr_api_transaction_steps
1890: where transaction_id=p_transaction_id;
1891:
1892: step_row csr_hat_steps%ROWTYPE;
1893:

Line 2102: lv_is_upgrade hr_api_transaction_steps.Information30%type;

2098: function getUpgradeCheck(p_transaction_id in number) return varchar2
2099:
2100: IS
2101: c_proc constant varchar2(30) := 'getUpgradeCheck';
2102: lv_is_upgrade hr_api_transaction_steps.Information30%type;
2103: begin
2104: g_debug := hr_utility.debug_enabled;
2105: if g_debug then
2106: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 2113: from hr_api_transaction_steps

2109: if(p_transaction_id is not null) then
2110: begin
2111: select Information30
2112: into lv_is_upgrade
2113: from hr_api_transaction_steps
2114: where transaction_id=p_transaction_id;
2115:
2116: exception
2117: when others then

Line 2243: from hr_api_transaction_steps trs

2239: l_eth_dff_exists varchar2(30):= null;
2240:
2241: cursor csr_txn_step_id is
2242: select trs.transaction_step_id
2243: from hr_api_transaction_steps trs
2244: where trs.transaction_id = hr_transaction_ss.get_transaction_id
2245: (itemtype ,itemkey )
2246: and trs.api_name ='HR_PROCESS_PERSON_SS.PROCESS_API';
2247:

Line 2834: select 'X' into dummy from hr_api_transaction_steps ts, hr_api_transactions hat

2830:
2831: begin
2832:
2833:
2834: select 'X' into dummy from hr_api_transaction_steps ts, hr_api_transactions hat
2835: where hat.item_type = itemtype
2836: and hat.item_key = itemkey
2837: and ts.transaction_id = hat.transaction_id
2838: and rownum <= 1;