DBA Data[Home] [Help]

APPS.CS_COST_DETAILS_PVT dependencies on CS_TRANSACTION_TYPES_B

Line 112: FROM CS_transaction_types_b

108: ) RETURN VARCHAR2 IS
109:
110: CURSOR c_transaction_type_id IS
111: SELECT 1
112: FROM CS_transaction_types_b
113: WHERE transaction_type_id = p_transaction_type_id
114: AND create_cost_flag = 'Y';
115:
116: lv_exists_flag VARCHAR2(1) := 'N';

Line 875: FROM cs_transaction_types_b

871: x_msg_data OUT NOCOPY VARCHAR2 ) IS
872:
873: CURSOR c_transaction_type_id IS
874: SELECT transaction_type_id,line_order_category_code
875: FROM cs_transaction_types_b
876: WHERE transaction_type_id = p_transaction_type_id;
877:
878: lv_exists_flag VARCHAR2(1) := 'N';
879:

Line 927: FROM cs_transaction_types_b

923: x_msg_data OUT NOCOPY VARCHAR2 ) IS
924:
925: CURSOR c_check_flag IS
926: SELECT create_charge_flag,create_cost_flag
927: FROM cs_transaction_types_b
928: WHERE transaction_type_id = p_transaction_type_id;
929:
930: CURSOR c_get_item_from_profile is
931: select fnd_profile.value('CS_DEFAULT_LABOR_ITEM') from dual;

Line 1043: FROM cs_transaction_types_b

1039:
1040: CURSOR SAC_FLAGS IS
1041: SELECT NVL(create_charge_flag,'Y') ,
1042: NVL(create_cost_flag,'N')
1043: FROM cs_transaction_types_b
1044: WHERE transaction_type_id = p_transaction_type_id;
1045:
1046: cursor c_charge_flags(p_incident_id IN NUMBER) IS
1047: SELECT nvl(csinst.disallow_new_charge, 'N'),