APPS.XLA_CMP_EVENT_TYPE_PKG dependencies on XLA_PROD_ACCT_HEADERS

Line 1324: FROM xla_prod_acct_headers xpah

1320: , xpah.event_class_code
1321: , xpah.entity_code
1322: , xeca.calculate_acctd_amts_flag
1323: , xeca.calculate_g_l_amts_flag
1324: FROM xla_prod_acct_headers xpah
1325: , xla_event_types_b xetb
1326: , xla_event_class_attrs xeca
1327: WHERE xpah.product_rule_code = p_product_rule_code
1328: AND xpah.product_rule_type_code = p_product_rule_type_code

Line 1356: FROM xla_prod_acct_headers xpah

1352: , xpah.event_class_code
1353: , xpah.entity_code
1354: , xeca.calculate_acctd_amts_flag
1355: , xeca.calculate_g_l_amts_flag
1356: FROM xla_prod_acct_headers xpah
1357: , xla_event_types_b xetb
1358: , xla_event_class_attrs xeca
1359: , xla_aad_line_defn_assgns xald
1360: , xla_line_definitions_b xld

Line 1416: (p_msg => 'SQL - Select from xla_prod_acct_headers '

1412:
1413: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1414:
1415: trace
1416: (p_msg => 'SQL - Select from xla_prod_acct_headers '
1417: ,p_level => C_LEVEL_STATEMENT
1418: ,p_module => l_log_module);
1419:
1420: END IF;

Line 1498: FROM xla_prod_acct_headers xpah

1494: CURSOR event_type_cur
1495: IS
1496: SELECT DISTINCT
1497: xetb.event_type_code
1498: FROM xla_prod_acct_headers xpah
1499: , xla_event_types_b xetb
1500: WHERE xpah.product_rule_code = p_product_rule_code
1501: AND xpah.product_rule_type_code = p_product_rule_type_code
1502: AND xpah.application_id = p_application_id

Line 1534: (p_msg => 'SQL - SELECT from xla_prod_acct_headers'

1530: ,p_module => l_log_module);
1531: END IF;
1532: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1533: trace
1534: (p_msg => 'SQL - SELECT from xla_prod_acct_headers'
1535: ,p_level => C_LEVEL_STATEMENT
1536: ,p_module => l_log_module);
1537: END IF;
1538:

Line 2389: FROM xla_prod_acct_headers xpah

2385: SELECT xpah.description_code
2386: , xpah.description_type_code
2387: INTO l_description_code
2388: , l_description_type_code
2389: FROM xla_prod_acct_headers xpah
2390: WHERE xpah.product_rule_type_code = p_product_rule_type_code
2391: AND xpah.product_rule_code = p_product_rule_code
2392: AND xpah.entity_code = p_entity
2393: AND xpah.event_class_code = p_event_class

Line 2496: , xla_prod_acct_headers xpah

2492: , xldj.line_definition_code
2493: , xldj.line_definition_owner_code
2494: FROM xla_aad_line_defn_assgns xald
2495: , xla_line_defn_jlt_assgns xldj
2496: , xla_prod_acct_headers xpah
2497: , xla_line_definitions_b xld
2498: WHERE xldj.line_definition_owner_code = xald.line_definition_owner_code
2499: AND xldj.line_definition_code = xald.line_definition_code
2500: AND xldj.event_class_code = xald.event_class_code