DBA Data[Home] [Help]

APPS.HR_PROCESS_SIT_SS dependencies on HR_API_TRANSACTION_STEPS

Line 947: from HR_API_TRANSACTION_STEPS t1

943:
944: --2287707
945: cursor csr_get_steps is
946: select t1.transaction_step_id
947: from HR_API_TRANSACTION_STEPS t1
948: where t1.api_name = 'HR_PROCESS_SIT_SS.PROCESS_API'
949: and t1.transaction_id = (select t2.transaction_id
950: from HR_API_TRANSACTION_STEPS t2
951: where t2.transaction_step_id = p_transaction_step_id)

Line 950: from HR_API_TRANSACTION_STEPS t2

946: select t1.transaction_step_id
947: from HR_API_TRANSACTION_STEPS t1
948: where t1.api_name = 'HR_PROCESS_SIT_SS.PROCESS_API'
949: and t1.transaction_id = (select t2.transaction_id
950: from HR_API_TRANSACTION_STEPS t2
951: where t2.transaction_step_id = p_transaction_step_id)
952: order by transaction_step_id;
953:
954: l_transaction_step_id HR_API_TRANSACTION_STEPS.transaction_step_id%TYPE;

Line 954: l_transaction_step_id HR_API_TRANSACTION_STEPS.transaction_step_id%TYPE;

950: from HR_API_TRANSACTION_STEPS t2
951: where t2.transaction_step_id = p_transaction_step_id)
952: order by transaction_step_id;
953:
954: l_transaction_step_id HR_API_TRANSACTION_STEPS.transaction_step_id%TYPE;
955: --2287707
956:
957: BEGIN
958: