APPS.AP_WEB_POLICY_UTILS dependencies on AP_POL_CAT_OPTIONS_ALL

Line 582: FROM AP_POL_CAT_OPTIONS_ALL pco,

578: pco.CATEGORY_CODE,
579: pco.ORG_ID,
580: pc.user_id,
581: pc.selected_org_id
582: FROM AP_POL_CAT_OPTIONS_ALL pco,
583: AP_POL_CONTEXT pc
584: WHERE pco.org_id(+) = pc.selected_org_id
585: AND pco.category_code(+) = p_category_code
586: AND pc.user_id = p_user_id;

Line 591: INSERT INTO ap_pol_cat_options_all

587:
588: BEGIN
589: FOR user_cat_options_rec IN user_cat_options_c LOOP
590: IF user_cat_options_rec.category_option_id is null THEN
591: INSERT INTO ap_pol_cat_options_all
592: (category_option_id,
593: category_code,
594: org_id,
595: distance_uom,