DBA Data[Home] [Help]

APPS.JTY_ASSIGN_BULK_PUB dependencies on JTY_TAE_ATTR_PRODUCTS_SQL

Line 2364: FROM jty_tae_attr_products_sql

2360: FOR jtf_csr IN c_get_qualrel_prod(p_source_id, p_trans_id) LOOP
2361: BEGIN
2362: SELECT batch_nmc_match_sql
2363: INTO l_match_sql
2364: FROM jty_tae_attr_products_sql
2365: WHERE source_id = p_source_id
2366: AND trans_type_id = p_trans_id
2367: AND program_name = p_program_name
2368: AND attr_relation_product = jtf_csr.relation_product;

Line 3992: FROM jty_tae_attr_products_sql

3988: FOR jtf_csr IN c_get_qualrel_prod(p_source_id, p_trans_id) LOOP
3989: BEGIN
3990: SELECT decode(p_mode, 'TOTAL', batch_match_sql, 'INCREMENTAL', batch_nm_match_sql)
3991: INTO l_match_sql
3992: FROM jty_tae_attr_products_sql
3993: WHERE source_id = p_source_id
3994: AND trans_type_id = p_trans_id
3995: AND program_name = p_program_name
3996: AND attr_relation_product = jtf_csr.relation_product;