DBA Data[Home] [Help]

APPS.ZX_MIGRATE_TAX_DEFAULT_HIER dependencies on ZX_CONDITIONS

Line 612: (select 1 from zx_conditions

608: fnd_global.conc_login_id ,
609: 1
610: )
611: WHEN (not exists
612: (select 1 from zx_conditions
613: where (condition_group_code = l_condition_group_code or
614: condition_group_code = l_old_condition_group_code)
615: and determining_factor_code = determining_factor_code1
616: and determining_factor_class_code =

Line 619: INTO ZX_CONDITIONS

615: and determining_factor_code = determining_factor_code1
616: and determining_factor_class_code =
617: determining_factor_class1_code)
618: ) THEN
619: INTO ZX_CONDITIONS
620: (
621: DETERMINING_FACTOR_CODE ,
622: CONDITION_GROUP_CODE ,
623: TAX_PARAMETER_CODE ,

Line 655: zx_conditions_s.nextval ,

651: OPERATOR1_CODE ,
652: 'MIGRATED' ,
653: 'N' ,
654: ALPHANUMERIC_VALUE1 ,
655: zx_conditions_s.nextval ,
656: fnd_global.user_id ,
657: SYSDATE ,
658: fnd_global.user_id ,
659: SYSDATE ,

Line 758: (select 1 from zx_conditions

754: fnd_global.conc_login_id ,
755: 1
756: )
757: WHEN (not exists
758: (select 1 from zx_conditions
759: where (condition_group_code = l_condition_group_code
760: or condition_group_code = l_old_condition_group_code)
761: and determining_factor_code = determining_factor_code1
762: and determining_factor_class_code =

Line 765: INTO ZX_CONDITIONS

761: and determining_factor_code = determining_factor_code1
762: and determining_factor_class_code =
763: determining_factor_class1_code)
764: ) THEN
765: INTO ZX_CONDITIONS
766: (
767: DETERMINING_FACTOR_CODE ,
768: CONDITION_GROUP_CODE ,
769: TAX_PARAMETER_CODE ,

Line 801: zx_conditions_s.nextval ,

797: OPERATOR1_CODE ,
798: 'MIGRATED' ,
799: 'N' ,
800: ALPHANUMERIC_VALUE1 ,
801: zx_conditions_s.nextval ,
802: fnd_global.user_id ,
803: SYSDATE ,
804: fnd_global.user_id ,
805: SYSDATE ,

Line 914: (select 1 from zx_conditions

910: fnd_global.conc_login_id ,
911: 1
912: )
913: WHEN (not exists
914: (select 1 from zx_conditions
915: where condition_group_code = l_condition_group_code
916: and determining_factor_code = determining_factor_code1
917: and determining_factor_class_code = determining_factor_class1_code)
918: ) THEN

Line 919: INTO ZX_CONDITIONS

915: where condition_group_code = l_condition_group_code
916: and determining_factor_code = determining_factor_code1
917: and determining_factor_class_code = determining_factor_class1_code)
918: ) THEN
919: INTO ZX_CONDITIONS
920: (
921: DETERMINING_FACTOR_CODE ,
922: CONDITION_GROUP_CODE ,
923: TAX_PARAMETER_CODE ,

Line 955: zx_conditions_s.nextval ,

951: OPERATOR1_CODE ,
952: 'MIGRATED' ,
953: 'N' ,
954: ALPHANUMERIC_VALUE1 ,
955: zx_conditions_s.nextval ,
956: fnd_global.user_id ,
957: SYSDATE ,
958: fnd_global.user_id ,
959: SYSDATE ,

Line 1255: (select 1 from zx_conditions

1251: 1
1252: )
1253: -- create conditions for tax_classification_code
1254: WHEN (not exists
1255: (select 1 from zx_conditions
1256: where condition_group_code = l_condition_group_code
1257: and determining_factor_code = determining_factor_code1
1258: and determining_factor_class_code =
1259: determining_factor_class1_code)

Line 1261: INTO ZX_CONDITIONS

1257: and determining_factor_code = determining_factor_code1
1258: and determining_factor_class_code =
1259: determining_factor_class1_code)
1260: ) THEN
1261: INTO ZX_CONDITIONS
1262: (
1263: DETERMINING_FACTOR_CODE ,
1264: CONDITION_GROUP_CODE ,
1265: TAX_PARAMETER_CODE ,

Line 1297: zx_conditions_s.nextval ,

1293: OPERATOR1_CODE ,
1294: 'MIGRATED' ,
1295: 'N' ,
1296: ALPHANUMERIC_VALUE1 ,
1297: zx_conditions_s.nextval ,
1298: fnd_global.user_id ,
1299: SYSDATE ,
1300: fnd_global.user_id ,
1301: SYSDATE ,

Line 1312: (select 1 from zx_conditions

1308: )
1309: -- create condition for product_fisc_classification
1310: WHEN ALPHANUMERIC_VALUE2 IS NOT NULL
1311: AND (not exists
1312: (select 1 from zx_conditions
1313: where condition_group_code = l_condition_group_code
1314: and determining_factor_code = determining_factor_code2
1315: and determining_factor_class_code =
1316: determining_factor_class2_code)

Line 1318: INTO ZX_CONDITIONS

1314: and determining_factor_code = determining_factor_code2
1315: and determining_factor_class_code =
1316: determining_factor_class2_code)
1317: ) THEN
1318: INTO ZX_CONDITIONS
1319: (
1320: DETERMINING_FACTOR_CODE ,
1321: CONDITION_GROUP_CODE ,
1322: TAX_PARAMETER_CODE ,

Line 1354: zx_conditions_s.nextval ,

1350: OPERATOR2_CODE ,
1351: 'MIGRATED' ,
1352: 'N' ,
1353: ALPHANUMERIC_VALUE2 ,
1354: zx_conditions_s.nextval ,
1355: fnd_global.user_id ,
1356: SYSDATE ,
1357: fnd_global.user_id ,
1358: SYSDATE ,

Line 1370: (select 1 from zx_conditions

1366:
1367: -- create condition for trx_business_category_code
1368: WHEN ALPHANUMERIC_VALUE3 IS NOT NULL
1369: AND (not exists
1370: (select 1 from zx_conditions
1371: where condition_group_code = l_condition_group_code
1372: and determining_factor_code = determining_factor_code3
1373: and determining_factor_class_code =
1374: determining_factor_class3_code)

Line 1376: INTO ZX_CONDITIONS

1372: and determining_factor_code = determining_factor_code3
1373: and determining_factor_class_code =
1374: determining_factor_class3_code)
1375: ) THEN
1376: INTO ZX_CONDITIONS
1377: (
1378: DETERMINING_FACTOR_CODE ,
1379: CONDITION_GROUP_CODE ,
1380: TAX_PARAMETER_CODE ,

Line 1412: zx_conditions_s.nextval ,

1408: OPERATOR3_CODE ,
1409: 'MIGRATED' ,
1410: 'N' ,
1411: ALPHANUMERIC_VALUE3 ,
1412: zx_conditions_s.nextval ,
1413: fnd_global.user_id ,
1414: SYSDATE ,
1415: fnd_global.user_id ,
1416: SYSDATE ,

Line 1428: (select 1 from zx_conditions

1424:
1425: -- create condition for party_fisc_classification
1426: WHEN ALPHANUMERIC_VALUE4 IS NOT NULL
1427: AND (not exists
1428: (select 1 from zx_conditions
1429: where condition_group_code = l_condition_group_code
1430: and determining_factor_code = determining_factor_code4
1431: and determining_factor_class_code =
1432: determining_factor_class4_code)

Line 1434: INTO ZX_CONDITIONS

1430: and determining_factor_code = determining_factor_code4
1431: and determining_factor_class_code =
1432: determining_factor_class4_code)
1433: ) THEN
1434: INTO ZX_CONDITIONS
1435: (
1436: DETERMINING_FACTOR_CODE ,
1437: CONDITION_GROUP_CODE ,
1438: TAX_PARAMETER_CODE ,

Line 1470: zx_conditions_s.nextval ,

1466: OPERATOR4_CODE ,
1467: 'MIGRATED' ,
1468: 'N' ,
1469: ALPHANUMERIC_VALUE4 ,
1470: zx_conditions_s.nextval ,
1471: fnd_global.user_id ,
1472: SYSDATE ,
1473: fnd_global.user_id ,
1474: SYSDATE ,