eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.ZX_FC_MIGRATE_PKG dependencies on ZX_FC_CODES_B_S

Line 747: --select zx_fc_codes_b_s.nextval into l_fc_id from dual;

743:
744: /* Create Codes under Product Category Statistical Code */
745: arp_util_tax.debug( 'Creating the Statistical Code.. ');
746:
747: --select zx_fc_codes_b_s.nextval into l_fc_id from dual;
748:
749: FIRST_LEVEL_FC_CODE_INSERT('PRODUCT_CATEGORY','STATISTICAL_CODE','Statistical Code',NULL,l_fc_id);
750:
751: FC_CODE_FROM_FND_LOOKUP('PRODUCT_CATEGORY','JGZZ_STATISTICAL_CODE',NULL,l_fc_id,'STATISTICAL_CODE','Statistical Code',2);

Line 798: zx_fc_codes_b_s.nextval,

794: last_update_login,
795: object_version_number)
796: ( SELECT
797: 'PRODUCT_CATEGORY',
798: zx_fc_codes_b_s.nextval,
799: lookups.LOOKUP_CODE fc_code,
800: nvl(START_DATE_ACTIVE, to_date('01/01/1951','DD/MM/YYYY')) effective_from,
801: END_DATE_ACTIVE effective_to,
802: 'FISCAL CLASSIFICATION CODE',--parent_classification_code

Line 1128: zx_fc_codes_b_s.nextval,

1124: last_update_date,
1125: last_update_login,
1126: object_version_number)
1127: (SELECT 'USER_DEFINED',
1128: zx_fc_codes_b_s.nextval,
1129: cfo_code,
1130: creation_date,
1131: null,
1132: null,----parent_classification_code

Line 1336: zx_fc_codes_b_s.nextval,

1332: object_version_number
1333: )
1334: SELECT
1335: 'TRX_BUSINESS_CATEGORY',
1336: zx_fc_codes_b_s.nextval,
1337: cfo_code ,
1338: ap_op.creation_date,
1339: null,
1340: fc.classification_code,--parent_classification_code

Line 1584: zx_fc_codes_b_s.nextval,

1580: last_update_login,
1581: object_version_number)
1582: SELECT
1583: 'DOCUMENT_SUBTYPE',
1584: zx_fc_codes_b_s.nextval,
1585: lookup_code, --classification_code
1586: nvl(start_date_active,to_date('01/01/1951','DD/MM/YYYY')), --effective_from
1587: end_date_active, --effective_to
1588: 'GUI TYPE', --parent_classification_code

Line 2074: --select zx_fc_codes_b_s.nextval into x_fc_id from dual;

2070: G_DELIMITER;
2071:
2072: CLOSE G_C_GET_TYPES_INFO;
2073:
2074: --select zx_fc_codes_b_s.nextval into x_fc_id from dual;
2075:
2076: INSERT
2077: INTO ZX_FC_CODES_B (
2078: classification_type_code,

Line 2094: zx_fc_codes_b_s.nextval,

2090: last_update_login,
2091: object_version_number)
2092: SELECT
2093: p_classification_type_code,
2094: zx_fc_codes_b_s.nextval,
2095: p_classification_code,
2096: Sysdate,
2097: Null,
2098: Null, ---parent_classification_code

Line 2320: zx_fc_codes_b_s.nextval,

2316: last_update_date,
2317: last_update_login,
2318: object_version_number)
2319: SELECT p_classification_type_code,
2320: zx_fc_codes_b_s.nextval,
2321: lookup_code,
2322: nvl(start_date_active,to_date('01/01/1951','DD/MM/YYYY')),
2323: end_date_active,
2324: p_ancestor_code,----parent_classification_code

Line 2572: zx_fc_codes_b_s.nextval,

2568: last_update_login,
2569: object_version_number)
2570: SELECT
2571: 'TRX_BUSINESS_CATEGORY',
2572: zx_fc_codes_b_s.nextval,
2573: lookup_code,
2574: nvl(start_date_active,to_date('01/01/1951','DD/MM/YYYY')) start_date_active,
2575: end_date_active,
2576: fc.classification_code ,---parent_classification_code

Line 2828: zx_fc_codes_b_s.nextval, --classification_id

2824: last_update_login,
2825: object_version_number)
2826: SELECT
2827: 'TRX_BUSINESS_CATEGORY', --classification_type_code
2828: zx_fc_codes_b_s.nextval, --classification_id
2829: p_classification_code, --classification_code
2830: sysdate, --effective_from
2831: null, --effective_to
2832: event.tax_event_class_code, --parent_classification_code

Line 3628: zx_fc_codes_b_s.nextval,

3624: last_update_login,
3625: object_version_number)
3626: SELECT
3627: 'DOCUMENT_SUBTYPE',
3628: zx_fc_codes_b_s.nextval,
3629: flex_value,
3630: nvl(start_date_active,to_date('01/01/1951','DD/MM/YYYY')),
3631: end_date_active,
3632: 'DEDUCTION TAX RULE',--parent_classification_code

Line 3854: zx_fc_codes_b_s.nextval,

3850: last_update_login,
3851: object_version_number)
3852: SELECT
3853: 'DOCUMENT_SUBTYPE',
3854: zx_fc_codes_b_s.nextval,
3855: lookup_code,
3856: nvl(start_date_active,to_date('01/01/1951','DD/MM/YYYY')),
3857: end_date_active,
3858: 'DOCUMENT TYPE',--parent_classification_code

Line 4153: zx_fc_codes_b_s.nextval, --classification_id

4149: last_update_login,
4150: object_version_number)
4151: SELECT
4152: 'TRX_BUSINESS_CATEGORY', --classification_type_code
4153: zx_fc_codes_b_s.nextval, --classification_id
4154: lookups.fc_code, --classification_code
4155: lookups.effective_from, --effective_from
4156: lookups.effective_to, --effective_to
4157: event.tax_event_class_code, --parent_classification_code

Line 4810: zx_fc_codes_b_s.nextval,

4806: last_update_date,
4807: last_update_login,
4808: object_version_number)
4809: (SELECT 'USER_DEFINED',
4810: zx_fc_codes_b_s.nextval,
4811: lookup_code, --classification_code
4812: nvl(start_date_active,sysdate), --effective_from
4813: end_date_active, --effective_to
4814: null,----parent_classification_code