APPS.CSFW_DEBRIEF_PUB dependencies on OE_TRANSACTION_TYPES_ALL

Line 1006: from oe_transaction_types_all

1002:
1003:
1004: cursor c_line_type_id_order (p_order_type_id number,p_incident_id Number) is
1005: select default_outbound_line_type_id
1006: from oe_transaction_types_all
1007: where transaction_type_id = p_order_type_id
1008: and transaction_type_code = 'ORDER';
1009:
1010: cursor c_line_type_id_return (p_order_type_id number,p_incident_id number) is

Line 1012: from oe_transaction_types_all

1008: and transaction_type_code = 'ORDER';
1009:
1010: cursor c_line_type_id_return (p_order_type_id number,p_incident_id number) is
1011: select default_inbound_line_type_id
1012: from oe_transaction_types_all
1013: where transaction_type_id = p_order_type_id
1014: and transaction_type_code = 'ORDER';
1015:
1016:

Line 1516: from oe_transaction_types_all

1512:
1513:
1514: cursor c_line_type_id_order (p_order_type_id number,p_incident_id Number) is
1515: select default_outbound_line_type_id
1516: from oe_transaction_types_all
1517: where transaction_type_id = p_order_type_id
1518: and transaction_type_code = 'ORDER';
1519:
1520: cursor c_line_type_id_return (p_order_type_id number,p_incident_id number) is

Line 1522: from oe_transaction_types_all

1518: and transaction_type_code = 'ORDER';
1519:
1520: cursor c_line_type_id_return (p_order_type_id number,p_incident_id number) is
1521: select default_inbound_line_type_id
1522: from oe_transaction_types_all
1523: where transaction_type_id = p_order_type_id
1524: and transaction_type_code = 'ORDER';
1525:
1526: Cursor c_status_meaning(p_code Varchar2) Is