APPS.PQH_SS_WORKFLOW dependencies on HR_API_TRANSACTION_STEPS

Line 46: FROM hr_api_transaction_steps

42: number_value = previous_number_value,
43: date_value = previous_date_value
44: WHERE transaction_step_id IN (
45: SELECT transaction_step_id
46: FROM hr_api_transaction_steps
47: WHERE transaction_id = p_transactionId
48: --AND api_name <> 'HR_SUPERVISOR_SS.PROCESS_API');
49: AND api_name NOT in ('HR_SUPERVISOR_SS.PROCESS_API'
50: ,'HR_PROCESS_SIT_SS.PROCESS_API'

Line 96: FROM hr_api_transaction_steps

92: previous_date_value = date_value,
93: previous_number_value = number_value
94: WHERE transaction_step_id IN (
95: SELECT transaction_step_id
96: FROM hr_api_transaction_steps
97: WHERE transaction_id = p_transactionId
98: --AND api_name <> 'HR_SUPERVISOR_SS.PROCESS_API');
99: AND api_name NOT in ('HR_SUPERVISOR_SS.PROCESS_API'
100: ,'HR_PROCESS_SIT_SS.PROCESS_API'

Line 791: FROM hr_api_transaction_steps

787: -- if so flag is set
788: -- Check if the transaction is on an assignment
789: CURSOR cur_chk_asg (c_txnId NUMBER) IS
790: SELECT 'X'
791: FROM hr_api_transaction_steps
792: WHERE transaction_id = c_txnId
793: AND api_name IN (
794: 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API',
795: 'HR_SUPERVISOR_SS.PROCESS_API',

Line 1115: FROM hr_api_transaction_steps

1111: Declare
1112: --
1113: CURSOR cur_asg_step IS
1114: SELECT transaction_step_id
1115: FROM hr_api_transaction_steps
1116: WHERE transaction_id = p_txnId
1117: AND api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API';
1118: --
1119: --

Line 1785: FROM hr_api_transaction_steps

1781: ,p_effectiveDateOption IN VARCHAR2 ) IS
1782: --
1783: CURSOR cur_asgn IS
1784: SELECT api_name,transaction_step_id
1785: FROM hr_api_transaction_steps
1786: WHERE transaction_id = p_txnId;
1787: --
1788: -- AND api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API';
1789: --

Line 2480: FROM hr_api_transaction_steps

2476: WHERE datatype = 'DATE'
2477: AND name = 'P_PASSED_EFFECTIVE_DATE'
2478: AND transaction_step_id = (
2479: SELECT transaction_step_id
2480: FROM hr_api_transaction_steps
2481: WHERE transaction_id = l_txnId
2482: AND api_name = 'HR_SUPERVISOR_SS.PROCESS_API' );
2483: --
2484: END IF;