APPS.FTE_LTL_LOADER dependencies on QP_LIST_HEADERS_B

Line 1010: QP_LIST_HEADERS_B

1006: END IF;
1007:
1008: FORALL i in 1..l_lane_ids.COUNT
1009: UPDATE
1010: QP_LIST_HEADERS_B
1011: SET
1012: START_DATE_ACTIVE = l_effective_dates(i),
1013: END_DATE_ACTIVE = l_expiry_dates(i),
1014: last_updated_by = G_USER_ID,

Line 1095: qp_list_headers_b b,

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
1099: WHERE

Line 1449: QP_LIST_HEADERS_B

1445: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'Deleting Data From QP Tables');
1446: END IF;
1447:
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);

Line 2240: qp_list_headers_b b

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
2244: l.language = userenv('LANG');