DBA Data[Home] [Help]

APPS.XLA_EXTRACT_INTEGRITY_PKG dependencies on XLA_PROD_ACCT_HEADERS

Line 352: FROM xla_prod_acct_headers h

348:
349: CURSOR c_aad_obj_exist
350: IS
351: SELECT h.entity_code, h.event_class_code
352: FROM xla_prod_acct_headers h
353: WHERE h.application_id = p_application_id
354: AND h.amb_context_code = p_amb_context_code
355: AND h.product_rule_type_code = p_product_rule_type_code
356: AND h.product_rule_code = p_product_rule_code

Line 414: FROM xla_extract_objects e, xla_prod_acct_headers h

410: ,e.event_class_code
411: ,e.object_name
412: ,e.object_type_code
413: ,C_REF_OBJECT_FLAG_N ref_object_flag
414: FROM xla_extract_objects e, xla_prod_acct_headers h
415: WHERE h.application_id = p_application_id
416: AND h.amb_context_code = p_amb_context_code
417: AND h.product_rule_type_code = p_product_rule_type_code
418: AND h.product_rule_code = p_product_rule_code

Line 434: xla_prod_acct_headers h

430: ,e.object_type_code
431: ,C_REF_OBJECT_FLAG_Y ref_object_flag
432: FROM xla_reference_objects r,
433: xla_extract_objects e,
434: xla_prod_acct_headers h
435: WHERE h.application_id = p_application_id
436: AND h.amb_context_code = p_amb_context_code
437: AND h.product_rule_type_code = p_product_rule_type_code
438: AND h.product_rule_code = p_product_rule_code

Line 1804: FROM xla_extract_objects ext, xla_prod_acct_headers hdr

1800:
1801: CURSOR c_aad_objects
1802: IS
1803: SELECT distinct ext.object_name, C_REF_OBJECT_FLAG_N reference_object_flag
1804: FROM xla_extract_objects ext, xla_prod_acct_headers hdr
1805: WHERE ext.application_id = hdr.application_id
1806: AND ext.entity_code = hdr.entity_code
1807: AND ext.event_class_code = hdr.event_class_code
1808: AND hdr.application_id = p_application_id

Line 1814: FROM xla_reference_objects rfr, xla_prod_acct_headers hdr

1810: AND hdr.product_rule_type_code = p_product_rule_type_code
1811: AND hdr.product_rule_code = p_product_rule_code
1812: UNION ALL
1813: SELECT distinct rfr.reference_object_name, C_REF_OBJECT_FLAG_Y reference_object_flag
1814: FROM xla_reference_objects rfr, xla_prod_acct_headers hdr
1815: WHERE rfr.application_id = hdr.application_id
1816: AND rfr.entity_code = hdr.entity_code
1817: AND rfr.event_class_code = hdr.event_class_code
1818: AND hdr.application_id = p_application_id