eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_FUND_RECONCILE_PVT dependencies on QP_LIST_HEADERS_B

Line 141: FROM ozf_offers off,qp_list_headers_b qp

137: p_end_date IN DATE) IS
138: SELECT qp_list_header_id object_id
139: ,nvl(transaction_currency_code,fund_request_curr_code) object_curr
140: --, qp.end_date_active object_date
141: FROM ozf_offers off,qp_list_headers_b qp
142: WHERE off.qp_list_header_id = qp.list_header_id
143: AND NVL (qp.end_date_active, p_grace_date) <= p_grace_date
144: AND status_code IN (p_status)
145: --AND offr.status_code IN ('CLOSED','COMPLETED','TERMINATED') -- inactive offers;

Line 1073: TYPE startDateTbl IS TABLE OF qp_list_headers_b.start_date_active%TYPE;

1069:
1070: TYPE listHeaderIdTbl IS TABLE OF ozf_offers.qp_list_header_id%TYPE;
1071: TYPE transCurrCodeTbl IS TABLE OF ozf_offers.transaction_currency_code%TYPE;
1072: TYPE lastRecalDateTbl IS TABLE OF ozf_offers.last_recal_date%TYPE;
1073: TYPE startDateTbl IS TABLE OF qp_list_headers_b.start_date_active%TYPE;
1074: TYPE endDateTbl IS TABLE OF qp_list_headers_b.end_date_active%TYPE;
1075: l_listHeaderIdTbl listHeaderIdTbl;
1076: l_transCurrCodeTbl transCurrCodeTbl;
1077: l_lastRecalDateTbl lastRecalDateTbl;

Line 1074: TYPE endDateTbl IS TABLE OF qp_list_headers_b.end_date_active%TYPE;

1070: TYPE listHeaderIdTbl IS TABLE OF ozf_offers.qp_list_header_id%TYPE;
1071: TYPE transCurrCodeTbl IS TABLE OF ozf_offers.transaction_currency_code%TYPE;
1072: TYPE lastRecalDateTbl IS TABLE OF ozf_offers.last_recal_date%TYPE;
1073: TYPE startDateTbl IS TABLE OF qp_list_headers_b.start_date_active%TYPE;
1074: TYPE endDateTbl IS TABLE OF qp_list_headers_b.end_date_active%TYPE;
1075: l_listHeaderIdTbl listHeaderIdTbl;
1076: l_transCurrCodeTbl transCurrCodeTbl;
1077: l_lastRecalDateTbl lastRecalDateTbl;
1078: l_startDateTbl startDateTbl;

Line 1088: FROM ozf_offers offs, qp_list_headers_b qpl

1084: ,qpl.start_date_active start_date_active
1085: ,qpl.end_date_active end_date_active
1086: ,NVL(offs.last_recal_date,qpl.start_date_active) last_recal_date -- changed to new column for last recal date
1087: --,qpl.description description
1088: FROM ozf_offers offs, qp_list_headers_b qpl
1089: WHERE offs.offer_type NOT IN ('LUMPSUM', 'TERMS','SCAN_DATA')
1090: AND offs.status_code = 'ACTIVE'
1091: AND NVL (offs.account_closed_flag, 'N') = 'N'
1092: AND offs.qp_list_header_id = qpl.list_header_id(+)

Line 1555: FROM qp_list_headers_b qpoffr, ozf_offers offr

1551:
1552: CURSOR c_offer_rec IS
1553: SELECT offr.qp_list_header_id offer_id,offr.offer_type
1554: ,offr.transaction_currency_code offer_curr
1555: FROM qp_list_headers_b qpoffr, ozf_offers offr
1556: WHERE offr.qp_list_header_id = qpoffr.list_header_id
1557: AND offr.status_code IN ('ACTIVE')
1558: AND offr.offer_type IN ('LUMPSUM', 'SCAN_DATA')
1559: AND NVL (offr.account_closed_flag, 'N') = 'N'