APPS.OKS_IBINT_PUB dependencies on OKS_SUBSCR_HEADER_B

Line 357: From Oks_subscr_header_b

353: where instance_id = p_cp_id;
354:
355: Cursor l_subscr_csr(p_instance_id Number) Is
356: Select instance_id
357: From Oks_subscr_header_b
358: Where instance_id = p_instance_id
359: And rownum < 2;
360:
361:

Line 2042: From Oks_subscr_header_b oks, Oks_instance_temp tmp

2038: OR (trunc(tmp.transaction_date) <= trunc(kl.start_date)) );
2039:
2040: Cursor check_subscription_instance Is
2041: Select 'Y'
2042: From Oks_subscr_header_b oks, Oks_instance_temp tmp
2043: Where oks.instance_id = tmp.old_customer_product_id;
2044:
2045: Cursor l_refnum_csr(p_cp_id NUMBER) IS
2046: select instance_number

Line 2816: From Oks_subscr_header_b

2812: RETURN VARCHAR2 IS
2813:
2814: Cursor l_subscr_csr Is
2815: Select 'Y' subscr_instance
2816: From Oks_subscr_header_b
2817: Where instance_id = p_instance_id
2818: And rownum < 2;
2819:
2820: l_subscr_instance VARCHAR2(1):= 'N';