APPS.FTE_LTL_LOADER dependencies on QP_LIST_HEADERS_TL

Line 660: qp_list_headers_tl qlht,

656: prc.value_from minimum_charge
657: FROM
658: fte_lanes l,
659: hz_parties hzp,
660: qp_list_headers_tl qlht,
661: wsh_regions_tl oz,
662: wsh_regions_tl dz,
663: fte_lane_rate_charts flrc,
664: fte_prc_parameters prc

Line 685: qp_list_headers_tl qlht

681: qlht.name rate_chart_name
682: FROM
683: fte_lanes l,
684: fte_lane_rate_charts flrc,
685: qp_list_headers_tl qlht
686: WHERE
687: l.tariff_name = p_tariff_name AND
688: l.lane_type = 'LTL_' || p_tariff_name || '_' || p_load_number AND
689: l.lane_id = flrc.lane_id AND

Line 1094: qp_list_headers_tl lh,

1090: MAX(ql.qualifier_attr_value),
1091: MAX(ql.qualifier_grouping_no),
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

Line 1452: FROM qp_list_headers_tl

1448: DELETE FROM
1449: QP_LIST_HEADERS_B
1450: WHERE
1451: list_header_id IN (SELECT list_header_id
1452: FROM qp_list_headers_tl
1453: WHERE name = l_chart_name);
1454: l_num_lh := l_num_lh + SQL%ROWCOUNT;
1455:
1456: DELETE FROM

Line 1460: FROM qp_list_headers_tl

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);
1462:
1463: l_num_ql := l_num_ql + SQL%ROWCOUNT;
1464:

Line 1469: FROM qp_list_headers_tl

1465: DELETE FROM
1466: QP_LIST_LINES
1467: WHERE
1468: list_header_id IN (SELECT list_header_id
1469: FROM qp_list_headers_tl
1470: WHERE name = l_chart_name);
1471: l_num_ll := l_num_ll + SQL%ROWCOUNT;
1472:
1473: DELETE FROM

Line 1476: FROM qp_list_headers_tl

1472:
1473: DELETE FROM
1474: QP_PRICING_ATTRIBUTES
1475: WHERE list_header_id IN (SELECT list_header_id
1476: FROM qp_list_headers_tl
1477: WHERE name = l_chart_name);
1478:
1479: l_num_at := l_num_at + SQL%ROWCOUNT;
1480:

Line 1485: FROM qp_list_headers_tl

1481: DELETE FROM
1482: FTE_LANE_RATE_CHARTS
1483: WHERE
1484: list_header_id IN (SELECT list_header_id
1485: FROM qp_list_headers_tl
1486: WHERE name = l_chart_name);
1487:
1488: l_num_lane := l_num_lane + SQL%ROWCOUNT;
1489:

Line 1491: QP_LIST_HEADERS_TL

1487:
1488: l_num_lane := l_num_lane + SQL%ROWCOUNT;
1489:
1490: DELETE FROM
1491: QP_LIST_HEADERS_TL
1492: WHERE name = l_chart_name;
1493:
1494: DELETE FROM
1495: FTE_INTERFACE_ZONES

Line 2239: qp_list_headers_tl l,

2235: l.list_header_id
2236: INTO
2237: l_list_header_id
2238: FROM
2239: qp_list_headers_tl l,
2240: qp_list_headers_b b
2241: WHERE
2242: l.list_header_id = b.list_header_id AND
2243: l.name = l_lanes_temp.rate_chart_name(i) AND