DBA Data[Home] [Help]

APPS.XLA_SOURCES_PKG dependencies on XLA_AAD_HDR_ACCT_ATTRS

Line 519: FROM xla_aad_hdr_acct_attrs r

515: IS
516: SELECT application_id, amb_context_code, product_rule_type_code, product_rule_code
517: FROM xla_product_rules_b a
518: WHERE exists (SELECT 'x'
519: FROM xla_aad_hdr_acct_attrs r
520: WHERE source_application_id = p_der_application_id
521: AND source_code = p_der_source_code
522: AND source_type_code = p_der_source_type_code
523: AND source_code is not null

Line 995: FROM xla_aad_hdr_acct_attrs xah, xla_prod_acct_headers xpa

991: IS
992: SELECT 'x'
993: FROM DUAL
994: WHERE EXISTS (SELECT 'x'
995: FROM xla_aad_hdr_acct_attrs xah, xla_prod_acct_headers xpa
996: WHERE xah.source_application_id = p_der_application_id
997: AND xah.source_code = p_der_source_code
998: AND xah.source_type_code = p_der_source_type_code
999: AND xah.source_type_code IS NOT NULL

Line 1271: FROM xla_aad_hdr_acct_attrs

1267:
1268: CURSOR check_aad_acct_attr
1269: IS
1270: SELECT 'x'
1271: FROM xla_aad_hdr_acct_attrs
1272: WHERE source_application_id = p_application_id
1273: AND source_code = p_source_code
1274: AND source_type_code = p_source_type_code;
1275:

Line 2059: FROM xla_aad_hdr_acct_attrs r, xla_prod_acct_headers p

2055: IS
2056: SELECT 'x'
2057: FROM DUAL
2058: WHERE EXISTS (SELECT 'x'
2059: FROM xla_aad_hdr_acct_attrs r, xla_prod_acct_headers p
2060: WHERE r.source_application_id = p_application_id
2061: AND r.source_code = p_source_code
2062: AND r.source_type_code = p_source_type_code
2063: AND r.source_type_code IS NOT NULL

Line 2549: FROM xla_aad_hdr_acct_attrs r

2545: SELECT application_id, amb_context_code,
2546: product_rule_type_code, product_rule_code
2547: FROM xla_product_rules_b a
2548: WHERE exists (SELECT 'x'
2549: FROM xla_aad_hdr_acct_attrs r
2550: WHERE source_application_id = p_application_id
2551: AND source_code = p_source_code
2552: AND source_type_code = p_source_type_code
2553: AND source_code is not null