APPS.IGI_EXP_TUS_PKG dependencies on DUAL

Line 515: FROM dual;

511: END IF;
512:
513: SELECT igi_exp_tus_s1.NEXTVAL
514: INTO x_tu_id
515: FROM dual;
516:
517: new_references.org_id := x_org_id;
518:
519: before_dml(

Line 1097: NVL ( TO_NUMBER ( DECODE ( SUBSTRB ( USERENV ('CLIENT_INFO' ), 1, 1 ), ' ', NULL, SUBSTRB (USERENV ('CLIENT_INFO'),1,10) ) ), NULL ) org_id FROM dual;

1093:
1094: FUNCTION get_org_id RETURN NUMBER AS
1095: CURSOR cur_orgid IS
1096: SELECT
1097: NVL ( TO_NUMBER ( DECODE ( SUBSTRB ( USERENV ('CLIENT_INFO' ), 1, 1 ), ' ', NULL, SUBSTRB (USERENV ('CLIENT_INFO'),1,10) ) ), NULL ) org_id FROM dual;
1098:
1099: lv_org_id Number(15);
1100:
1101: BEGIN