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 794: FROM hr_api_transaction_steps

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

Line 1136: FROM hr_api_transaction_steps

1132: Declare
1133: --
1134: CURSOR cur_asg_step IS
1135: SELECT transaction_step_id
1136: FROM hr_api_transaction_steps
1137: WHERE transaction_id = p_txnId
1138: AND api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API';
1139: --
1140: --

Line 1808: FROM hr_api_transaction_steps

1804: ,p_effectiveDateOption IN VARCHAR2 ) IS
1805: --
1806: CURSOR cur_asgn IS
1807: SELECT api_name,transaction_step_id
1808: FROM hr_api_transaction_steps
1809: WHERE transaction_id = p_txnId;
1810: --
1811: -- AND api_name = 'HR_PROCESS_ASSIGNMENT_SS.PROCESS_API';
1812: --

Line 2503: FROM hr_api_transaction_steps

2499: WHERE datatype = 'DATE'
2500: AND name = 'P_PASSED_EFFECTIVE_DATE'
2501: AND transaction_step_id = (
2502: SELECT transaction_step_id
2503: FROM hr_api_transaction_steps
2504: WHERE transaction_id = l_txnId
2505: AND api_name = 'HR_SUPERVISOR_SS.PROCESS_API' );
2506: --
2507: END IF;