APPS.IBW_REFERRAL_PVT dependencies on IBW_URL_PATTERNS_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:

Line 118: INSERT INTO ibw_url_patterns_b (url_pattern_id, url_pattern, type_id, type, created_by, creation_date,

114: FROM ibw_referral_categories_b M, fnd_languages l, fnd_languages b
115: WHERE l.installed_flag IN ('I','B') AND b.installed_flag='B' AND M.referral_category_id=x_ref_cat_id;
116:
117:
118: INSERT INTO ibw_url_patterns_b (url_pattern_id, url_pattern, type_id, type, created_by, creation_date,
119: last_updated_by, last_update_date, last_update_login, object_version_number,
120: program_id, program_login_id, program_application_id, request_id)
121: VALUES (x_ref_pat_id, x_referral_pattern, x_ref_cat_id, 'R', created_by, creation_date,
122: last_updated_by, last_update_date, last_update_login, obj_ver_number,

Line 131: FROM ibw_url_patterns_b M, fnd_languages l, fnd_languages b

127: program_id, program_login_id, program_application_id, request_id)
128: SELECT M.url_pattern_id, l.language_code, b.language_code, NULL, M.created_by, M.creation_date,
129: M.last_updated_by, M.last_update_date, M.last_update_login, M.object_version_number,
130: M.program_id, M.program_login_id, M.program_application_id, M.request_id
131: FROM ibw_url_patterns_b M, fnd_languages l, fnd_languages b
132: WHERE l.installed_flag IN ('I','B') AND b.installed_flag='B' AND M.url_pattern_id=x_ref_pat_id;
133:
134:
135: OPEN c2;