DBA Data[Home] [Help]

APPS.JTY_ASSIGN_BULK_PUB dependencies on JTY_TAE_ATTR_PRODUCTS_SQL

Line 2222: FROM jty_tae_attr_products_sql

2218: FOR jtf_csr IN c_get_qualrel_prod(p_source_id, p_trans_id) LOOP
2219: BEGIN
2220: SELECT batch_nmc_match_sql
2221: INTO l_match_sql
2222: FROM jty_tae_attr_products_sql
2223: WHERE source_id = p_source_id
2224: AND trans_type_id = p_trans_id
2225: AND program_name = p_program_name
2226: AND attr_relation_product = jtf_csr.relation_product;

Line 3818: FROM jty_tae_attr_products_sql

3814: FOR jtf_csr IN c_get_qualrel_prod(p_source_id, p_trans_id) LOOP
3815: BEGIN
3816: SELECT decode(p_mode, 'TOTAL', batch_match_sql, 'INCREMENTAL', batch_nm_match_sql)
3817: INTO l_match_sql
3818: FROM jty_tae_attr_products_sql
3819: WHERE source_id = p_source_id
3820: AND trans_type_id = p_trans_id
3821: AND program_name = p_program_name
3822: AND attr_relation_product = jtf_csr.relation_product;