APPS.BEN_PROCESS_COMPENSATION_W dependencies on HR_API_TRANSACTION_STEPS

Line 25: from hr_api_transaction_steps hats

21: ,p_rows out nocopy number) is
22: --
23: cursor csr_hats is
24: select hats.transaction_step_id
25: from hr_api_transaction_steps hats
26: where hats.item_type = p_item_type
27: and hats.item_key = p_item_key
28: and hats.activity_id = p_activity_id
29: and hats.api_name = upper(g_package || 'process_api')

Line 1045: hr_api_transaction_steps stp,

1041: --
1042: cursor c_step_id is
1043: select stp.transaction_step_id
1044: from hr_api_transactions trn,
1045: hr_api_transaction_steps stp,
1046: hr_api_transaction_values vlv
1047: where trn.selected_person_id = p_person_id
1048: and trn.transaction_id = stp.transaction_id
1049: and stp.api_name = upper(g_package || 'process_api')

Line 1622: delete hr_api_transaction_steps step

1618: --
1619: delete hr_api_transaction_values vlv
1620: where vlv.transaction_step_id = l_step.transaction_step_id;
1621: --
1622: delete hr_api_transaction_steps step
1623: where step.transaction_step_id = l_step.transaction_step_id;
1624: --
1625: end loop;
1626: --