DBA Data[Home] [Help]

APPS.ZX_AP_TAX_CLASSIFICATN_DEF_PKG dependencies on ZX_PRODUCT_OPTIONS_ALL

Line 3107: FROM zx_product_options_all

3103: def_option_hier_4_code,
3104: def_option_hier_5_code,
3105: def_option_hier_6_code,
3106: def_option_hier_7_code
3107: FROM zx_product_options_all
3108: WHERE org_id = c_org_id
3109: AND application_id = c_application_id
3110: AND event_class_mapping_id IS NULL;
3111:

Line 3115: -- in zx_product_options_all

3111:
3112: --
3113: -- Bug#4102742- handle Internet Expense
3114: -- only IOE has event_class_mapping_id not NULL
3115: -- in zx_product_options_all
3116: --
3117: CURSOR c_get_event_class_mapping_id (
3118: c_event_class_code VARCHAR2,
3119: c_application_id NUMBER,

Line 3140: FROM zx_product_options_all

3136: def_option_hier_4_code,
3137: def_option_hier_5_code,
3138: def_option_hier_6_code,
3139: def_option_hier_7_code
3140: FROM zx_product_options_all
3141: WHERE org_id = c_org_id
3142: AND application_id = c_application_id
3143: AND event_class_mapping_id = c_event_class_mapping_id;
3144: BEGIN

Line 3347: FROM zx_product_options_all

3343: def_option_hier_4_code,
3344: def_option_hier_5_code,
3345: def_option_hier_6_code,
3346: def_option_hier_7_code
3347: FROM zx_product_options_all
3348: WHERE org_id = c_org_id
3349: AND application_id = c_application_id
3350: AND event_class_mapping_id IS NULL;
3351:

Line 3514: FROM zx_product_options_all

3510: def_option_hier_4_code,
3511: def_option_hier_5_code,
3512: def_option_hier_6_code,
3513: def_option_hier_7_code
3514: FROM zx_product_options_all
3515: WHERE org_id = c_org_id
3516: AND application_id = c_application_id
3517: AND event_class_mapping_id IS NULL;
3518: