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_CLAIM_PVT dependencies on OZF_OFFERS

Line 3814: FROM ozf_offers

3810:
3811: -- Added For Rule Based Settlement
3812: CURSOR csr_offer_id(p_offer_code in varchar2) is
3813: SELECT qp_list_header_id
3814: FROM ozf_offers
3815: WHERE offer_code = p_offer_code;
3816:
3817: -- Added For Bug 8924230
3818: CURSOR csr_offer_id_ignoreCase(p_offer_code in varchar2) is

Line 3820: FROM ozf_offers

3816:
3817: -- Added For Bug 8924230
3818: CURSOR csr_offer_id_ignoreCase(p_offer_code in varchar2) is
3819: SELECT qp_list_header_id
3820: FROM ozf_offers
3821: WHERE UPPER(offer_code) = UPPER(p_offer_code)
3822: AND ROWNUM = 1
3823: ORDER BY creation_date;
3824:

Line 6337: FROM ozf_offers

6333: GROUP BY cln.source_object_id;
6334:
6335: CURSOR csr_offer_code(p_offer_id in number) is
6336: SELECT offer_code
6337: FROM ozf_offers
6338: WHERE qp_list_header_id = p_offer_id;
6339:
6340: CURSOR csr_claim_line_offr(p_id in number) is
6341: SELECT activity_id