DBA Data[Home] [Help]

APPS.ZX_MIGRATE_TAX_DEFAULT_HIER dependencies on ZX_CONDITIONS

Line 609: (select 1 from zx_conditions

605: fnd_global.conc_login_id ,
606: 1
607: )
608: WHEN (not exists
609: (select 1 from zx_conditions
610: where condition_group_code = l_condition_group_code
611: and determining_factor_code = determining_factor_code1
612: and determining_factor_class_code =
613: determining_factor_class1_code)

Line 615: INTO ZX_CONDITIONS

611: and determining_factor_code = determining_factor_code1
612: and determining_factor_class_code =
613: determining_factor_class1_code)
614: ) THEN
615: INTO ZX_CONDITIONS
616: (
617: DETERMINING_FACTOR_CODE ,
618: CONDITION_GROUP_CODE ,
619: TAX_PARAMETER_CODE ,

Line 651: zx_conditions_s.nextval ,

647: OPERATOR1_CODE ,
648: 'MIGRATED' ,
649: 'N' ,
650: ALPHANUMERIC_VALUE1 ,
651: zx_conditions_s.nextval ,
652: fnd_global.user_id ,
653: SYSDATE ,
654: fnd_global.user_id ,
655: SYSDATE ,

Line 752: (select 1 from zx_conditions

748: fnd_global.conc_login_id ,
749: 1
750: )
751: WHEN (not exists
752: (select 1 from zx_conditions
753: where condition_group_code = l_condition_group_code
754: and determining_factor_code = determining_factor_code1
755: and determining_factor_class_code =
756: determining_factor_class1_code)

Line 758: INTO ZX_CONDITIONS

754: and determining_factor_code = determining_factor_code1
755: and determining_factor_class_code =
756: determining_factor_class1_code)
757: ) THEN
758: INTO ZX_CONDITIONS
759: (
760: DETERMINING_FACTOR_CODE ,
761: CONDITION_GROUP_CODE ,
762: TAX_PARAMETER_CODE ,

Line 794: zx_conditions_s.nextval ,

790: OPERATOR1_CODE ,
791: 'MIGRATED' ,
792: 'N' ,
793: ALPHANUMERIC_VALUE1 ,
794: zx_conditions_s.nextval ,
795: fnd_global.user_id ,
796: SYSDATE ,
797: fnd_global.user_id ,
798: SYSDATE ,

Line 1099: (select 1 from zx_conditions

1095: 1
1096: )
1097: -- create conditions for tax_classification_code
1098: WHEN (not exists
1099: (select 1 from zx_conditions
1100: where condition_group_code = l_condition_group_code
1101: and determining_factor_code = determining_factor_code1
1102: and determining_factor_class_code =
1103: determining_factor_class1_code)

Line 1105: INTO ZX_CONDITIONS

1101: and determining_factor_code = determining_factor_code1
1102: and determining_factor_class_code =
1103: determining_factor_class1_code)
1104: ) THEN
1105: INTO ZX_CONDITIONS
1106: (
1107: DETERMINING_FACTOR_CODE ,
1108: CONDITION_GROUP_CODE ,
1109: TAX_PARAMETER_CODE ,

Line 1141: zx_conditions_s.nextval ,

1137: OPERATOR1_CODE ,
1138: 'MIGRATED' ,
1139: 'N' ,
1140: ALPHANUMERIC_VALUE1 ,
1141: zx_conditions_s.nextval ,
1142: fnd_global.user_id ,
1143: SYSDATE ,
1144: fnd_global.user_id ,
1145: SYSDATE ,

Line 1156: (select 1 from zx_conditions

1152: )
1153: -- create condition for product_fisc_classification
1154: WHEN ALPHANUMERIC_VALUE2 IS NOT NULL
1155: AND (not exists
1156: (select 1 from zx_conditions
1157: where condition_group_code = l_condition_group_code
1158: and determining_factor_code = determining_factor_code2
1159: and determining_factor_class_code =
1160: determining_factor_class2_code)

Line 1162: INTO ZX_CONDITIONS

1158: and determining_factor_code = determining_factor_code2
1159: and determining_factor_class_code =
1160: determining_factor_class2_code)
1161: ) THEN
1162: INTO ZX_CONDITIONS
1163: (
1164: DETERMINING_FACTOR_CODE ,
1165: CONDITION_GROUP_CODE ,
1166: TAX_PARAMETER_CODE ,

Line 1198: zx_conditions_s.nextval ,

1194: OPERATOR2_CODE ,
1195: 'MIGRATED' ,
1196: 'N' ,
1197: ALPHANUMERIC_VALUE2 ,
1198: zx_conditions_s.nextval ,
1199: fnd_global.user_id ,
1200: SYSDATE ,
1201: fnd_global.user_id ,
1202: SYSDATE ,

Line 1214: (select 1 from zx_conditions

1210:
1211: -- create condition for trx_business_category_code
1212: WHEN ALPHANUMERIC_VALUE3 IS NOT NULL
1213: AND (not exists
1214: (select 1 from zx_conditions
1215: where condition_group_code = l_condition_group_code
1216: and determining_factor_code = determining_factor_code3
1217: and determining_factor_class_code =
1218: determining_factor_class3_code)

Line 1220: INTO ZX_CONDITIONS

1216: and determining_factor_code = determining_factor_code3
1217: and determining_factor_class_code =
1218: determining_factor_class3_code)
1219: ) THEN
1220: INTO ZX_CONDITIONS
1221: (
1222: DETERMINING_FACTOR_CODE ,
1223: CONDITION_GROUP_CODE ,
1224: TAX_PARAMETER_CODE ,

Line 1256: zx_conditions_s.nextval ,

1252: OPERATOR3_CODE ,
1253: 'MIGRATED' ,
1254: 'N' ,
1255: ALPHANUMERIC_VALUE3 ,
1256: zx_conditions_s.nextval ,
1257: fnd_global.user_id ,
1258: SYSDATE ,
1259: fnd_global.user_id ,
1260: SYSDATE ,

Line 1272: (select 1 from zx_conditions

1268:
1269: -- create condition for party_fisc_classification
1270: WHEN ALPHANUMERIC_VALUE4 IS NOT NULL
1271: AND (not exists
1272: (select 1 from zx_conditions
1273: where condition_group_code = l_condition_group_code
1274: and determining_factor_code = determining_factor_code4
1275: and determining_factor_class_code =
1276: determining_factor_class4_code)

Line 1278: INTO ZX_CONDITIONS

1274: and determining_factor_code = determining_factor_code4
1275: and determining_factor_class_code =
1276: determining_factor_class4_code)
1277: ) THEN
1278: INTO ZX_CONDITIONS
1279: (
1280: DETERMINING_FACTOR_CODE ,
1281: CONDITION_GROUP_CODE ,
1282: TAX_PARAMETER_CODE ,

Line 1314: zx_conditions_s.nextval ,

1310: OPERATOR4_CODE ,
1311: 'MIGRATED' ,
1312: 'N' ,
1313: ALPHANUMERIC_VALUE4 ,
1314: zx_conditions_s.nextval ,
1315: fnd_global.user_id ,
1316: SYSDATE ,
1317: fnd_global.user_id ,
1318: SYSDATE ,