APPS.ZX_AP_TAX_CLASSIFICATN_DEF_PKG dependencies on ZX_PRODUCT_OPTIONS_ALL

Line 2513: FROM zx_product_options_all

2509: def_option_hier_4_code,
2510: def_option_hier_5_code,
2511: def_option_hier_6_code,
2512: def_option_hier_7_code
2513: FROM zx_product_options_all
2514: WHERE org_id = c_org_id
2515: AND application_id = c_application_id
2516: AND event_class_mapping_id IS NULL;
2517:

Line 2521: -- in zx_product_options_all

2517:
2518: --
2519: -- Bug#4102742- handle Internet Expense
2520: -- only IOE has event_class_mapping_id not NULL
2521: -- in zx_product_options_all
2522: --
2523: CURSOR c_get_event_class_mapping_id (
2524: c_event_class_code VARCHAR2,
2525: c_application_id NUMBER,

Line 2546: FROM zx_product_options_all

2542: def_option_hier_4_code,
2543: def_option_hier_5_code,
2544: def_option_hier_6_code,
2545: def_option_hier_7_code
2546: FROM zx_product_options_all
2547: WHERE org_id = c_org_id
2548: AND application_id = c_application_id
2549: AND event_class_mapping_id = c_event_class_mapping_id;
2550: BEGIN

Line 2753: FROM zx_product_options_all

2749: def_option_hier_4_code,
2750: def_option_hier_5_code,
2751: def_option_hier_6_code,
2752: def_option_hier_7_code
2753: FROM zx_product_options_all
2754: WHERE org_id = c_org_id
2755: AND application_id = c_application_id
2756: AND event_class_mapping_id IS NULL;
2757:

Line 2920: FROM zx_product_options_all

2916: def_option_hier_4_code,
2917: def_option_hier_5_code,
2918: def_option_hier_6_code,
2919: def_option_hier_7_code
2920: FROM zx_product_options_all
2921: WHERE org_id = c_org_id
2922: AND application_id = c_application_id
2923: AND event_class_mapping_id IS NULL;
2924: