APPS.IBW_REFERRAL_PVT dependencies on DUAL

Line 64: CURSOR c IS SELECT ibw_referral_categories_b_s1.nextval FROM dual;

60: program_login_id NUMBER;
61: program_app_id NUMBER;
62: request_id NUMBER;
63:
64: CURSOR c IS SELECT ibw_referral_categories_b_s1.nextval FROM dual;
65:
66: CURSOR c1 IS SELECT ibw_url_patterns_b_s1.nextval FROM dual;
67:
68: CURSOR c2 IS SELECT referral_category_id FROM ibw_referral_categories_b

Line 66: CURSOR c1 IS SELECT ibw_url_patterns_b_s1.nextval FROM dual;

62: request_id NUMBER;
63:
64: CURSOR c IS SELECT ibw_referral_categories_b_s1.nextval FROM dual;
65:
66: CURSOR c1 IS SELECT ibw_url_patterns_b_s1.nextval FROM dual;
67:
68: CURSOR c2 IS SELECT referral_category_id FROM ibw_referral_categories_b
69: WHERE referral_category_id = x_ref_cat_id;
70: