DBA Data[Home] [Help]

APPS.FTE_LTL_LOADER dependencies on QP_QUALIFIERS

Line 1096: qp_qualifiers ql,

1092: MAX(b.start_date_active)
1093: FROM
1094: qp_list_headers_tl lh,
1095: qp_list_headers_b b,
1096: qp_qualifiers ql,
1097: fte_lane_rate_charts lrc,
1098: fte_lanes l
1099: WHERE
1100: l.tariff_name = p_tariff_name AND

Line 1457: QP_QUALIFIERS

1453: WHERE name = l_chart_name);
1454: l_num_lh := l_num_lh + SQL%ROWCOUNT;
1455:
1456: DELETE FROM
1457: QP_QUALIFIERS
1458: WHERE
1459: list_header_id IN (SELECT list_header_id
1460: FROM qp_list_headers_tl
1461: WHERE name = l_chart_name);

Line 1529: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Deleted ' || l_num_ql || ' from QP_QUALIFIERS');

1525: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1526: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Deleted ' || l_num_lh || ' from QP_LIST_HEADERS');
1527: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Deleted ' || l_num_ll || ' from QP_LIST_LINES');
1528: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Deleted ' || l_num_at || ' from QP_PRICINg_ATTRIBUTES');
1529: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Deleted ' || l_num_ql || ' from QP_QUALIFIERS');
1530: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Deleted ' || l_num_ln || ' from FTE_INTERFACE_LANES');
1531: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Deleted ' || l_num_zn || ' from FTE_INTERFACE_ZONES');
1532: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Deleted ' || l_num_lane || ' from FTE_LANES');
1533: END IF;