APPS.PQH_SS_UTILITY dependencies on HR_API_TRANSACTION_VALUES

Line 465: FROM hr_api_transaction_values tsv

461: AND t.status in ('Y','YS','RO','ROS') -- not considering C, RI, RIS as they are with init
462: AND ts.api_name IN ('HR_SUPERVISOR_SS.PROCESS_API','HR_PROCESS_ASSIGNMENT_SS.PROCESS_API',
463: 'HR_PAY_RATE_SS.PROCESS_API', 'HR_TERMINATION_SS.PROCESS_API' )
464: AND EXISTS (SELECT NULL
465: FROM hr_api_transaction_values tsv
466: WHERE tsv.transaction_step_id = ts.transaction_step_id
467: AND tsv.name = 'P_REVIEW_PROC_CALL'
468: AND tsv.varchar2_value IS NOT NULL)
469: AND EXISTS (SELECT NULL

Line 608: UPDATE hr_api_transaction_values

604: l_mode := 'CORRECTION';
605: END IF;
606: CLOSE cur_asgn;
607:
608: UPDATE hr_api_transaction_values
609: SET varchar2_value = l_mode
610: WHERE name = 'P_DATETRACK_UPDATE_MODE'
611: AND transaction_step_id = (
612: SELECT transaction_step_id

Line 794: FROM hr_api_transaction_values atv,

790: CURSOR csr_transaction_values IS
791: SELECT name,
792: atv.varchar2_value|| atv.number_value||atv.date_value txn_curr_value,
793: atv.original_varchar2_value|| atv.original_number_value||atv.original_date_value txn_old_value
794: FROM hr_api_transaction_values atv,
795: pqh_attributes att,
796: pqh_table_route ptr
797: WHERE att.column_name = name
798: AND att.master_table_route_id = ptr.table_route_id

Line 814: FROM hr_api_transaction_values

810: AND assignment_type IN ('E','A','C');
811: --
812: CURSOR cur_val (p_stepId NUMBER, p_param_name VARCHAR2) IS
813: SELECT NVL(original_number_value,number_value)
814: FROM hr_api_transaction_values
815: WHERE transaction_step_id = p_stepId
816: AND name = p_param_name;
817: --
818: CURSOR cur_txnStep (c_txnId NUMBER ) IS