APPS.AP_WEB_POLICY_UTILS dependencies on AP_POL_CAT_OPTIONS_ALL

Line 571: FROM AP_POL_CAT_OPTIONS_ALL pco,

567: pco.CATEGORY_CODE,
568: pco.ORG_ID,
569: pc.user_id,
570: pc.selected_org_id
571: FROM AP_POL_CAT_OPTIONS_ALL pco,
572: AP_POL_CONTEXT pc
573: WHERE pco.org_id(+) = pc.selected_org_id
574: AND pco.category_code(+) = p_category_code
575: AND pc.user_id = p_user_id;

Line 580: INSERT INTO ap_pol_cat_options_all

576:
577: BEGIN
578: FOR user_cat_options_rec IN user_cat_options_c LOOP
579: IF user_cat_options_rec.category_option_id is null THEN
580: INSERT INTO ap_pol_cat_options_all
581: (category_option_id,
582: category_code,
583: org_id,
584: distance_uom,