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 144: FROM ozf_offers off,qp_list_headers_b qp

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

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

1082:
1083: TYPE listHeaderIdTbl IS TABLE OF ozf_offers.qp_list_header_id%TYPE;
1084: TYPE transCurrCodeTbl IS TABLE OF ozf_offers.transaction_currency_code%TYPE;
1085: TYPE lastRecalDateTbl IS TABLE OF ozf_offers.last_recal_date%TYPE;
1086: TYPE startDateTbl IS TABLE OF qp_list_headers_b.start_date_active%TYPE;
1087: TYPE endDateTbl IS TABLE OF qp_list_headers_b.end_date_active%TYPE;
1088: l_listHeaderIdTbl listHeaderIdTbl;
1089: l_transCurrCodeTbl transCurrCodeTbl;
1090: l_lastRecalDateTbl lastRecalDateTbl;

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

1083: TYPE listHeaderIdTbl IS TABLE OF ozf_offers.qp_list_header_id%TYPE;
1084: TYPE transCurrCodeTbl IS TABLE OF ozf_offers.transaction_currency_code%TYPE;
1085: TYPE lastRecalDateTbl IS TABLE OF ozf_offers.last_recal_date%TYPE;
1086: TYPE startDateTbl IS TABLE OF qp_list_headers_b.start_date_active%TYPE;
1087: TYPE endDateTbl IS TABLE OF qp_list_headers_b.end_date_active%TYPE;
1088: l_listHeaderIdTbl listHeaderIdTbl;
1089: l_transCurrCodeTbl transCurrCodeTbl;
1090: l_lastRecalDateTbl lastRecalDateTbl;
1091: l_startDateTbl startDateTbl;

Line 1101: FROM ozf_offers offs, qp_list_headers_b qpl

1097: ,qpl.start_date_active start_date_active
1098: ,qpl.end_date_active end_date_active
1099: ,NVL(offs.last_recal_date,qpl.start_date_active) last_recal_date -- changed to new column for last recal date
1100: --,qpl.description description
1101: FROM ozf_offers offs, qp_list_headers_b qpl
1102: WHERE offs.offer_type NOT IN ('LUMPSUM', 'TERMS','SCAN_DATA')
1103: AND offs.status_code = 'ACTIVE'
1104: AND NVL (offs.account_closed_flag, 'N') = 'N'
1105: AND offs.qp_list_header_id = qpl.list_header_id(+)

Line 1568: FROM qp_list_headers_b qpoffr, ozf_offers offr

1564:
1565: CURSOR c_offer_rec IS
1566: SELECT offr.qp_list_header_id offer_id,offr.offer_type
1567: ,offr.transaction_currency_code offer_curr
1568: FROM qp_list_headers_b qpoffr, ozf_offers offr
1569: WHERE offr.qp_list_header_id = qpoffr.list_header_id
1570: AND offr.status_code IN ('ACTIVE')
1571: AND offr.offer_type IN ('LUMPSUM', 'SCAN_DATA')
1572: AND NVL (offr.account_closed_flag, 'N') = 'N'