DBA Data[Home] [Help]

APPS.ZX_SIM_CONDITIONS_PKG dependencies on FND_GLOBAL

Line 85: fnd_global.user_id created_by,

81: priority,
82: det_factor_templ_code,
83: effective_from,
84: 'N' simulated_flag,
85: fnd_global.user_id created_by,
86: sysdate creation_date,
87: fnd_global.user_id last_updated_by,
88: sysdate last_update_date,
89: last_update_login,

Line 87: fnd_global.user_id last_updated_by,

83: effective_from,
84: 'N' simulated_flag,
85: fnd_global.user_id created_by,
86: sysdate creation_date,
87: fnd_global.user_id last_updated_by,
88: sysdate last_update_date,
89: last_update_login,
90: effective_to,
91: application_id,

Line 124: fnd_global.user_id created_by,

120: SELECT tax_rule_id,
121: language,
122: source_lang,
123: tax_rule_name,
124: fnd_global.user_id created_by,
125: sysdate creation_date,
126: fnd_global.user_id last_updated_by,
127: sysdate last_update_date,
128: last_update_login

Line 126: fnd_global.user_id last_updated_by,

122: source_lang,
123: tax_rule_name,
124: fnd_global.user_id created_by,
125: sysdate creation_date,
126: fnd_global.user_id last_updated_by,
127: sysdate last_update_date,
128: last_update_login
129: FROM zx_rules_tl
130: WHERE tax_rule_id IN (select sim_tax_rule_id

Line 159: fnd_global.user_id created_by,

155: tax_rule_id,
156: condition_group_code,
157: priority,
158: 'N' simulated_flag,
159: fnd_global.user_id created_by,
160: sysdate creation_date,
161: fnd_global.user_id last_updated_by,
162: sysdate last_update_date,
163: last_update_login,

Line 161: fnd_global.user_id last_updated_by,

157: priority,
158: 'N' simulated_flag,
159: fnd_global.user_id created_by,
160: sysdate creation_date,
161: fnd_global.user_id last_updated_by,
162: sysdate last_update_date,
163: last_update_login,
164: result_type_code,
165: tax_status_code,

Line 207: fnd_global.user_id created_by,

203: data_type_code,
204: operator_code,
205: ignore_flag,
206: 'N' simulated_flag,
207: fnd_global.user_id created_by,
208: sysdate creation_date,
209: fnd_global.user_id last_updated_by,
210: sysdate last_update_date,
211: last_update_login,

Line 209: fnd_global.user_id last_updated_by,

205: ignore_flag,
206: 'N' simulated_flag,
207: fnd_global.user_id created_by,
208: sysdate creation_date,
209: fnd_global.user_id last_updated_by,
210: sysdate last_update_date,
211: last_update_login,
212: tax_parameter_code,
213: determining_factor_cq_code,

Line 429: fnd_global.user_id,

425: value_high,
426: trx_line_id,
427: trx_id,
428: tax_line_number,
429: fnd_global.user_id,
430: sysdate,
431: fnd_global.user_id,
432: sysdate)
433: Select pr_detfactor_class_tab(j) determining_factor_class_code,

Line 431: fnd_global.user_id,

427: trx_id,
428: tax_line_number,
429: fnd_global.user_id,
430: sysdate,
431: fnd_global.user_id,
432: sysdate)
433: Select pr_detfactor_class_tab(j) determining_factor_class_code,
434: pr_detfactor_cq_tab(j) determining_factor_cq_code,
435: pr_detfactor_code_tab(j) determining_factor_code,

Line 610: fnd_global.user_id created_by,

606: creation_date,
607: last_updated_by,
608: last_update_date)
609: SELECT l_rule_id sim_tax_rule_id,
610: fnd_global.user_id created_by,
611: sysdate creation_date,
612: fnd_global.user_id last_updated_by,
613: sysdate last_update_date
614: FROM dual

Line 612: fnd_global.user_id last_updated_by,

608: last_update_date)
609: SELECT l_rule_id sim_tax_rule_id,
610: fnd_global.user_id created_by,
611: sysdate creation_date,
612: fnd_global.user_id last_updated_by,
613: sysdate last_update_date
614: FROM dual
615: WHERE exists (Select 1
616: from zx_sim_conditions

Line 660: fnd_global.user_id created_by,

656: value_low,
657: value_high,
658: 'N' ignore_flag,
659: 'Y' simulated_flag,
660: fnd_global.user_id created_by,
661: sysdate creation_date,
662: fnd_global.user_id last_updated_by,
663: sysdate last_update_date
664: FROM zx_sim_conditions

Line 662: fnd_global.user_id last_updated_by,

658: 'N' ignore_flag,
659: 'Y' simulated_flag,
660: fnd_global.user_id created_by,
661: sysdate creation_date,
662: fnd_global.user_id last_updated_by,
663: sysdate last_update_date
664: FROM zx_sim_conditions
665: WHERE trx_id = p_trx_id
666: and trx_line_id = p_trxline_id

Line 737: fnd_global.user_id created_by,

733: creation_date,
734: last_updated_by,
735: last_update_date)
736: SELECT l_rule_id sim_tax_rule_id,
737: fnd_global.user_id created_by,
738: sysdate creation_date,
739: fnd_global.user_id last_updated_by,
740: sysdate last_update_date
741: FROM dual

Line 739: fnd_global.user_id last_updated_by,

735: last_update_date)
736: SELECT l_rule_id sim_tax_rule_id,
737: fnd_global.user_id created_by,
738: sysdate creation_date,
739: fnd_global.user_id last_updated_by,
740: sysdate last_update_date
741: FROM dual
742: WHERE exists (Select 1
743: from zx_sim_conditions

Line 858: fnd_global.user_id created_by,

854: creation_date,
855: last_updated_by,
856: last_update_date)
857: SELECT l_rule_id sim_tax_rule_id,
858: fnd_global.user_id created_by,
859: sysdate creation_date,
860: fnd_global.user_id last_updated_by,
861: sysdate last_update_date
862: FROM dual

Line 860: fnd_global.user_id last_updated_by,

856: last_update_date)
857: SELECT l_rule_id sim_tax_rule_id,
858: fnd_global.user_id created_by,
859: sysdate creation_date,
860: fnd_global.user_id last_updated_by,
861: sysdate last_update_date
862: FROM dual
863: WHERE exists (Select 1
864: from zx_sim_conditions

Line 930: fnd_global.user_id created_by,

926: userenv('LANG'),
927: b.tax_rule_code,
928: b.sim_tax_rule_id,
929: sysdate creation_date,
930: fnd_global.user_id created_by,
931: sysdate last_update_date,
932: fnd_global.user_id last_updated_by
933: from fnd_languages l,
934: zx_sim_rules_b b

Line 932: fnd_global.user_id last_updated_by

928: b.sim_tax_rule_id,
929: sysdate creation_date,
930: fnd_global.user_id created_by,
931: sysdate last_update_date,
932: fnd_global.user_id last_updated_by
933: from fnd_languages l,
934: zx_sim_rules_b b
935: where l.installed_flag in ('I', 'B')
936: and not exists

Line 1027: fnd_global.user_id,

1023: VALUES (to_number(substr(det_factor_templ_code,9)),
1024: det_factor_templ_code,
1025: 'TAX_RULES',
1026: 'USER_DEFINED',
1027: fnd_global.user_id,
1028: sysdate,
1029: fnd_global.user_id,
1030: sysdate)
1031: SELECT det_factor_templ_code

Line 1029: fnd_global.user_id,

1025: 'TAX_RULES',
1026: 'USER_DEFINED',
1027: fnd_global.user_id,
1028: sysdate,
1029: fnd_global.user_id,
1030: sysdate)
1031: SELECT det_factor_templ_code
1032: FROM zx_sim_rules_b
1033: WHERE simulated_flag = 'Y'

Line 1056: fnd_global.user_id created_by,

1052: userenv('LANG'),
1053: b.det_factor_templ_code,
1054: b.det_factor_templ_id,
1055: sysdate creation_date,
1056: fnd_global.user_id created_by,
1057: sysdate last_update_date,
1058: fnd_global.user_id last_updated_by
1059: from fnd_languages l,
1060: zx_det_factor_templ_b b

Line 1058: fnd_global.user_id last_updated_by

1054: b.det_factor_templ_id,
1055: sysdate creation_date,
1056: fnd_global.user_id created_by,
1057: sysdate last_update_date,
1058: fnd_global.user_id last_updated_by
1059: from fnd_languages l,
1060: zx_det_factor_templ_b b
1061: where l.installed_flag in ('I', 'B')
1062: and exists (Select NULL

Line 1097: fnd_global.user_id,

1093: determining_factor_cq_code,
1094: determining_factor_code,
1095: required_flag,
1096: 'USER_DEFINED',
1097: fnd_global.user_id,
1098: sysdate,
1099: fnd_global.user_id,
1100: sysdate)
1101: SELECT to_number(substr(rule.det_factor_templ_code,9)) det_factor_templ_id,

Line 1099: fnd_global.user_id,

1095: required_flag,
1096: 'USER_DEFINED',
1097: fnd_global.user_id,
1098: sysdate,
1099: fnd_global.user_id,
1100: sysdate)
1101: SELECT to_number(substr(rule.det_factor_templ_code,9)) det_factor_templ_id,
1102: determining_factor_class_code,
1103: determining_factor_cq_code,

Line 1140: fnd_global.user_id,

1136: det_factor_templ_code,
1137: 'USER_DEFINED',
1138: 'Y',
1139: 'Y',
1140: fnd_global.user_id,
1141: sysdate,
1142: fnd_global.user_id,
1143: sysdate)
1144: SELECT condition_group_code,

Line 1142: fnd_global.user_id,

1138: 'Y',
1139: 'Y',
1140: fnd_global.user_id,
1141: sysdate,
1142: fnd_global.user_id,
1143: sysdate)
1144: SELECT condition_group_code,
1145: det_factor_templ_code
1146: FROM zx_sim_rules_b rule,

Line 1172: fnd_global.user_id created_by,

1168: userenv('LANG'),
1169: b.condition_group_code,
1170: b.condition_group_id,
1171: sysdate creation_date,
1172: fnd_global.user_id created_by,
1173: sysdate last_update_date,
1174: fnd_global.user_id last_updated_by
1175: from fnd_languages l,
1176: zx_condition_groups_b b

Line 1174: fnd_global.user_id last_updated_by

1170: b.condition_group_id,
1171: sysdate creation_date,
1172: fnd_global.user_id created_by,
1173: sysdate last_update_date,
1174: fnd_global.user_id last_updated_by
1175: from fnd_languages l,
1176: zx_condition_groups_b b
1177: where l.installed_flag in ('I', 'B')
1178: and exists (Select NULL

Line 1386: fnd_global.user_id created_by,

1382: determining_factor_code,
1383: data_type_code,
1384: operator_code,
1385: ignore_flag,
1386: fnd_global.user_id created_by,
1387: sysdate creation_date,
1388: fnd_global.user_id last_updated_by,
1389: sysdate last_update_date,
1390: tax_parameter_code,

Line 1388: fnd_global.user_id last_updated_by,

1384: operator_code,
1385: ignore_flag,
1386: fnd_global.user_id created_by,
1387: sysdate creation_date,
1388: fnd_global.user_id last_updated_by,
1389: sysdate last_update_date,
1390: tax_parameter_code,
1391: determining_factor_cq_code,
1392: 'USER_DEFINED',

Line 1436: fnd_global.user_id created_by,

1432: det_factor_templ_code,
1433: effective_from,
1434: 'Y',
1435: 'USER_DEFINED',
1436: fnd_global.user_id created_by,
1437: sysdate creation_date,
1438: fnd_global.user_id last_updated_by,
1439: sysdate last_update_date
1440: FROM zx_sim_rules_b

Line 1438: fnd_global.user_id last_updated_by,

1434: 'Y',
1435: 'USER_DEFINED',
1436: fnd_global.user_id created_by,
1437: sysdate creation_date,
1438: fnd_global.user_id last_updated_by,
1439: sysdate last_update_date
1440: FROM zx_sim_rules_b
1441: WHERE simulated_flag = 'Y';
1442:

Line 1463: fnd_global.user_id created_by,

1459: userenv('LANG'),
1460: b.tax_rule_code,
1461: b.tax_rule_id,
1462: sysdate creation_date,
1463: fnd_global.user_id created_by,
1464: sysdate last_update_date,
1465: fnd_global.user_id last_updated_by
1466: from fnd_languages l,
1467: zx_rules_b b

Line 1465: fnd_global.user_id last_updated_by

1461: b.tax_rule_id,
1462: sysdate creation_date,
1463: fnd_global.user_id created_by,
1464: sysdate last_update_date,
1465: fnd_global.user_id last_updated_by
1466: from fnd_languages l,
1467: zx_rules_b b
1468: where l.installed_flag in ('I', 'B')
1469: and exists (Select NULL

Line 1528: fnd_global.user_id created_by,

1524: result.numeric_result,
1525: result.alphanumeric_result,
1526: 'Y',
1527: 'USER_DEFINED',
1528: fnd_global.user_id created_by,
1529: sysdate creation_date,
1530: fnd_global.user_id last_updated_by,
1531: sysdate last_update_date
1532: FROM zx_sim_rules_b rule,

Line 1530: fnd_global.user_id last_updated_by,

1526: 'Y',
1527: 'USER_DEFINED',
1528: fnd_global.user_id created_by,
1529: sysdate creation_date,
1530: fnd_global.user_id last_updated_by,
1531: sysdate last_update_date
1532: FROM zx_sim_rules_b rule,
1533: zx_sim_process_results result
1534: WHERE result.sim_tax_rule_id = rule.sim_tax_rule_id