APPS.ZX_FC_MIGRATE_PKG dependencies on ZX_EVENT_CLASSES_VL

Line 12: p_tax_event_class_code IN ZX_EVENT_CLASSES_VL.TAX_EVENT_CLASS_CODE%TYPE

8: PROCEDURE GDF_PROMPT_INSERT(
9: p_classification_code IN ZX_FC_CODES_B.CLASSIFICATION_CODE%TYPE,
10: p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,
11: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
12: p_tax_event_class_code IN ZX_EVENT_CLASSES_VL.TAX_EVENT_CLASS_CODE%TYPE
13: );
14:
15: /* COMMON PROCEDURE USED TO ASSOCIATE THE ITEMS */
16: PROCEDURE ASSOCIATE_ITEMS(

Line 1356: ZX_EVENT_CLASSES_VL event

1352: 1
1353: FROM
1354: JL_BR_AP_OPERATIONS ap_op,
1355: ZX_FC_CODES_DENORM_B fc,
1356: ZX_EVENT_CLASSES_VL event
1357: WHERE
1358: fc.classification_type_code = 'TRX_BUSINESS_CATEGORY'
1359: and fc.classification_code='OPERATION FISCAL CODE'
1360: and fc.ancestor_code = event.tax_event_class_code

Line 1509: ZX_EVENT_CLASSES_VL event

1505: ZX_FC_CODES_DENORM_B fc,
1506: ZX_FC_CODES_B Codes,
1507: JL_BR_AP_OPERATIONS ap_op,
1508: FND_LANGUAGES L,
1509: ZX_EVENT_CLASSES_VL event
1510: WHERE
1511: fc.classification_type_code = 'TRX_BUSINESS_CATEGORY'
1512: and fc.classification_code='OPERATION FISCAL CODE'
1513: and fc.language = userenv('LANG')

Line 2511: p_tax_event_class_code IN ZX_EVENT_CLASSES_VL.TAX_EVENT_CLASS_CODE%TYPE,

2507: p_classification_code IN ZX_FC_CODES_B.CLASSIFICATION_CODE%TYPE,
2508: p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,
2509: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
2510: p_lookup_type IN FND_LOOKUP_VALUES.LOOKUP_TYPE%TYPE,
2511: p_tax_event_class_code IN ZX_EVENT_CLASSES_VL.TAX_EVENT_CLASS_CODE%TYPE,
2512: p_record_type_code IN ZX_FC_CODES_B.RECORD_TYPE_CODE%TYPE
2513: )
2514:
2515: IS

Line 2581: ZX_EVENT_CLASSES_VL event,

2577: decode(p_record_type_code, 'SEEDED', 0, fnd_global.conc_login_id),
2578: 1
2579: FROM
2580: ZX_FC_CODES_DENORM_B fc,
2581: ZX_EVENT_CLASSES_VL event,
2582: FND_LOOKUP_VALUES FL
2583: WHERE
2584: fc.classification_type_code = 'TRX_BUSINESS_CATEGORY'
2585: and fc.classification_code=p_classification_code

Line 2628: ZX_EVENT_CLASSES_VL event,

2624: l.language_code,
2625: SOURCE_LANG
2626: FROM
2627: ZX_FC_CODES_DENORM_B fc,
2628: ZX_EVENT_CLASSES_VL event,
2629: FND_LOOKUP_VALUES FL,
2630: zx_fc_codes_b inserted_fc,
2631: FND_LANGUAGES L
2632: WHERE

Line 2758: ZX_EVENT_CLASSES_VL event,

2754: p_record_type_code
2755: FROM
2756: ZX_FC_CODES_DENORM_B fc,
2757: ZX_FC_CODES_b Codes,
2758: ZX_EVENT_CLASSES_VL event,
2759: FND_LOOKUP_VALUES FL,
2760: FND_LANGUAGES L
2761: WHERE fc.classification_type_code = 'TRX_BUSINESS_CATEGORY'
2762: and fc.classification_code = p_classification_code

Line 2804: p_tax_event_class_code IN ZX_EVENT_CLASSES_VL.TAX_EVENT_CLASS_CODE%TYPE

2800: PROCEDURE GDF_PROMPT_INSERT(
2801: p_classification_code IN ZX_FC_CODES_B.CLASSIFICATION_CODE%TYPE,
2802: p_classification_name IN ZX_FC_CODES_TL.CLASSIFICATION_NAME%TYPE,
2803: p_country_code IN ZX_FC_CODES_B.COUNTRY_CODE%TYPE,
2804: p_tax_event_class_code IN ZX_EVENT_CLASSES_VL.TAX_EVENT_CLASS_CODE%TYPE
2805: )
2806:
2807: IS
2808:

Line 4382: ZX_EVENT_CLASSES_VL event,

4378:
4379: FROM
4380:
4381: ZX_FC_CODES_B fc,
4382: ZX_EVENT_CLASSES_VL event,
4383: (SELECT
4384: lookups.LOOKUP_CODE fc_code,
4385: nvl(START_DATE_ACTIVE,to_date('01/01/1951','DD/MM/YYYY')) effective_from,
4386: END_DATE_ACTIVE effective_to

Line 4545: ZX_EVENT_CLASSES_VL event,

4541: codes.enabled_flag
4542: FROM
4543:
4544: ZX_FC_CODES_B fc,
4545: ZX_EVENT_CLASSES_VL event,
4546:
4547: (SELECT
4548: FL.LOOKUP_CODE fc_code,
4549: FL.MEANING fc_name,