APPS.XLA_CMP_EVENT_TYPE_PKG dependencies on XLA_PROD_ACCT_HEADERS

Line 1336: FROM xla_prod_acct_headers xpah

1332: , xpah.event_class_code
1333: , xpah.entity_code
1334: , xeca.calculate_acctd_amts_flag
1335: , xeca.calculate_g_l_amts_flag
1336: FROM xla_prod_acct_headers xpah
1337: , xla_event_types_b xetb
1338: , xla_event_class_attrs xeca
1339: WHERE xpah.product_rule_code = p_product_rule_code
1340: AND xpah.product_rule_type_code = p_product_rule_type_code

Line 1368: FROM xla_prod_acct_headers xpah

1364: , xpah.event_class_code
1365: , xpah.entity_code
1366: , xeca.calculate_acctd_amts_flag
1367: , xeca.calculate_g_l_amts_flag
1368: FROM xla_prod_acct_headers xpah
1369: , xla_event_types_b xetb
1370: , xla_event_class_attrs xeca
1371: , xla_aad_line_defn_assgns xald
1372: , xla_line_definitions_b xld

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

1424:
1425: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1426:
1427: trace
1428: (p_msg => 'SQL - Select from xla_prod_acct_headers '
1429: ,p_level => C_LEVEL_STATEMENT
1430: ,p_module => l_log_module);
1431:
1432: END IF;

Line 1510: FROM xla_prod_acct_headers xpah

1506: CURSOR event_type_cur
1507: IS
1508: SELECT DISTINCT
1509: xetb.event_type_code
1510: FROM xla_prod_acct_headers xpah
1511: , xla_event_types_b xetb
1512: WHERE xpah.product_rule_code = p_product_rule_code
1513: AND xpah.product_rule_type_code = p_product_rule_type_code
1514: AND xpah.application_id = p_application_id

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

1542: ,p_module => l_log_module);
1543: END IF;
1544: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1545: trace
1546: (p_msg => 'SQL - SELECT from xla_prod_acct_headers'
1547: ,p_level => C_LEVEL_STATEMENT
1548: ,p_module => l_log_module);
1549: END IF;
1550:

Line 2401: FROM xla_prod_acct_headers xpah

2397: SELECT xpah.description_code
2398: , xpah.description_type_code
2399: INTO l_description_code
2400: , l_description_type_code
2401: FROM xla_prod_acct_headers xpah
2402: WHERE xpah.product_rule_type_code = p_product_rule_type_code
2403: AND xpah.product_rule_code = p_product_rule_code
2404: AND xpah.entity_code = p_entity
2405: AND xpah.event_class_code = p_event_class

Line 2508: , xla_prod_acct_headers xpah

2504: , xldj.line_definition_code
2505: , xldj.line_definition_owner_code
2506: FROM xla_aad_line_defn_assgns xald
2507: , xla_line_defn_jlt_assgns xldj
2508: , xla_prod_acct_headers xpah
2509: , xla_line_definitions_b xld
2510: WHERE xldj.line_definition_owner_code = xald.line_definition_owner_code
2511: AND xldj.line_definition_code = xald.line_definition_code
2512: AND xldj.event_class_code = xald.event_class_code