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 760: --select zx_fc_codes_b_s.nextval into l_fc_id from dual;

756:
757: /* Create Codes under Product Category Statistical Code */
758: arp_util_tax.debug( 'Creating the Statistical Code.. ');
759:
760: --select zx_fc_codes_b_s.nextval into l_fc_id from dual;
761:
762: FIRST_LEVEL_FC_CODE_INSERT('PRODUCT_CATEGORY','STATISTICAL_CODE','Statistical Code',NULL,l_fc_id);
763:
764: FC_CODE_FROM_FND_LOOKUP('PRODUCT_CATEGORY','JGZZ_STATISTICAL_CODE',NULL,l_fc_id,'STATISTICAL_CODE','Statistical Code',2);

Line 811: zx_fc_codes_b_s.nextval,

807: last_update_login,
808: object_version_number)
809: (SELECT
810: 'PRODUCT_CATEGORY',
811: zx_fc_codes_b_s.nextval,
812: lookups.LOOKUP_CODE fc_code,
813: nvl(START_DATE_ACTIVE, to_date('01/01/1951','DD/MM/YYYY')) effective_from,
814: END_DATE_ACTIVE effective_to,
815: 'FISCAL CLASSIFICATION CODE',--parent_classification_code

Line 1133: zx_fc_codes_b_s.nextval,

1129: last_update_date,
1130: last_update_login,
1131: object_version_number)
1132: (SELECT 'USER_DEFINED',
1133: zx_fc_codes_b_s.nextval,
1134: cfo_code,
1135: creation_date,
1136: null,
1137: null,----parent_classification_code

Line 1339: zx_fc_codes_b_s.nextval,

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

Line 1585: zx_fc_codes_b_s.nextval,

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

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

2063: G_DELIMITER;
2064:
2065: CLOSE G_C_GET_TYPES_INFO;
2066:
2067: --select zx_fc_codes_b_s.nextval into x_fc_id from dual;
2068:
2069: INSERT
2070: INTO ZX_FC_CODES_B (
2071: classification_type_code,

Line 2087: zx_fc_codes_b_s.nextval,

2083: last_update_login,
2084: object_version_number)
2085: SELECT
2086: p_classification_type_code,
2087: zx_fc_codes_b_s.nextval,
2088: p_classification_code,
2089: Sysdate,
2090: Null,
2091: Null, ---parent_classification_code

Line 2313: zx_fc_codes_b_s.nextval,

2309: last_update_date,
2310: last_update_login,
2311: object_version_number)
2312: SELECT p_classification_type_code,
2313: zx_fc_codes_b_s.nextval,
2314: lookup_code,
2315: nvl(start_date_active,to_date('01/01/1951','DD/MM/YYYY')),
2316: end_date_active,
2317: p_ancestor_code,----parent_classification_code

Line 2565: zx_fc_codes_b_s.nextval,

2561: last_update_login,
2562: object_version_number)
2563: SELECT
2564: fc.classification_type_code,
2565: zx_fc_codes_b_s.nextval,
2566: lookup_code,
2567: nvl(start_date_active,to_date('01/01/1951','DD/MM/YYYY')) start_date_active,
2568: end_date_active,
2569: fc.classification_code ,---parent_classification_code

Line 2848: zx_fc_codes_b_s.nextval, --classification_id

2844: last_update_login,
2845: object_version_number)
2846: SELECT
2847: 'TRX_BUSINESS_CATEGORY', --classification_type_code
2848: zx_fc_codes_b_s.nextval, --classification_id
2849: p_classification_code, --classification_code
2850: sysdate, --effective_from
2851: null, --effective_to
2852: event.tax_event_class_code, --parent_classification_code

Line 3827: zx_fc_codes_b_s.nextval,

3823: last_update_login,
3824: object_version_number)
3825: SELECT
3826: 'DOCUMENT_SUBTYPE',
3827: zx_fc_codes_b_s.nextval,
3828: flex_value,
3829: nvl(start_date_active,to_date('01/01/1951','DD/MM/YYYY')),
3830: end_date_active,
3831: 'DEDUCTION TAX RULE',--parent_classification_code

Line 4054: zx_fc_codes_b_s.nextval,

4050: last_update_login,
4051: object_version_number)
4052: SELECT
4053: 'DOCUMENT_SUBTYPE',
4054: zx_fc_codes_b_s.nextval,
4055: lookup_code,
4056: nvl(start_date_active,to_date('01/01/1951','DD/MM/YYYY')),
4057: end_date_active,
4058: 'DOCUMENT TYPE',--parent_classification_code

Line 4364: zx_fc_codes_b_s.nextval, --classification_id

4360: last_update_login,
4361: object_version_number)
4362: SELECT
4363: 'TRX_BUSINESS_CATEGORY', --classification_type_code
4364: zx_fc_codes_b_s.nextval, --classification_id
4365: lookups.fc_code, --classification_code
4366: lookups.effective_from, --effective_from
4367: lookups.effective_to, --effective_to
4368: event.tax_event_class_code, --parent_classification_code

Line 5034: zx_fc_codes_b_s.nextval,

5030: last_update_date,
5031: last_update_login,
5032: object_version_number)
5033: (SELECT 'USER_DEFINED',
5034: zx_fc_codes_b_s.nextval,
5035: lookup_code, --classification_code
5036: nvl(start_date_active,sysdate), --effective_from
5037: end_date_active, --effective_to
5038: null,----parent_classification_code