DBA Data[Home] [Help]

APPS.JTY_ASSIGN_BULK_PUB dependencies on JTY_DEA_ATTR_PRODUCTS_SQL

Line 3768: FROM jty_dea_attr_products_sql

3764: FOR jtf_csr IN c_dea_get_qualrel_prod(p_source_id, p_trans_id) LOOP
3765: BEGIN
3766: SELECT batch_dea_match_sql
3767: INTO l_match_sql
3768: FROM jty_dea_attr_products_sql
3769: WHERE source_id = p_source_id
3770: AND trans_type_id = p_trans_id
3771: AND program_name = p_program_name
3772: AND attr_relation_product = jtf_csr.attr_relation_product;

Line 3792: FROM jty_dea_attr_products_sql

3788: FOR jtf_csr IN c_dea_get_qualrel_prod(p_source_id, p_trans_id) LOOP
3789: BEGIN
3790: SELECT batch_dea_match_sql_with_terr
3791: INTO l_match_sql
3792: FROM jty_dea_attr_products_sql
3793: WHERE source_id = p_source_id
3794: AND trans_type_id = p_trans_id
3795: AND program_name = p_program_name
3796: AND attr_relation_product = jtf_csr.attr_relation_product;