APPS.OKS_IBINT_PUB dependencies on OKS_SUBSCR_HEADER_B

Line 361: From Oks_subscr_header_b

357: where instance_id = p_cp_id;
358:
359: Cursor l_subscr_csr(p_instance_id Number) Is
360: Select instance_id
361: From Oks_subscr_header_b
362: Where instance_id = p_instance_id
363: And rownum < 2;
364:
365:

Line 2022: From Oks_subscr_header_b oks, Oks_instance_temp tmp

2018: OR (trunc(tmp.transaction_date) <= trunc(kl.start_date)) );
2019:
2020: Cursor check_subscription_instance Is
2021: Select 'Y'
2022: From Oks_subscr_header_b oks, Oks_instance_temp tmp
2023: Where oks.instance_id = tmp.old_customer_product_id;
2024:
2025: Cursor l_refnum_csr(p_cp_id NUMBER) IS
2026: select instance_number

Line 2796: From Oks_subscr_header_b

2792: RETURN VARCHAR2 IS
2793:
2794: Cursor l_subscr_csr Is
2795: Select 'Y' subscr_instance
2796: From Oks_subscr_header_b
2797: Where instance_id = p_instance_id
2798: And rownum < 2;
2799:
2800: l_subscr_instance VARCHAR2(1):= 'N';