APPS.JTY_TAE_GEN_PVT dependencies on JTY_DEA_ATTR_PRODUCTS_SQL

Line 1542: FROM jty_dea_attr_products_sql

1538:
1539: IF ((p_mode = 'DATE EFFECTIVE') or (p_mode = 'DEA INCREMENTAL')) THEN
1540: SELECT count(*)
1541: INTO l_no_of_records
1542: FROM jty_dea_attr_products_sql
1543: WHERE source_id = p_source_id
1544: AND trans_type_id = p_trans_id
1545: AND program_name = l_pgm_name_tbl(i)
1546: AND attr_relation_product = p_qual_prd_tbl(j);

Line 1672: INSERT INTO JTY_DEA_ATTR_PRODUCTS_SQL(

1668: );
1669:
1670: ELSE
1671: l_match_sql_terr_based := l_match_sql || ' AND B.terr_id = :p_territory_id';
1672: INSERT INTO JTY_DEA_ATTR_PRODUCTS_SQL(
1673: DEA_ATTR_PRODUCTS_SQL_ID
1674: ,SOURCE_ID
1675: ,TRANS_TYPE_ID
1676: ,PROGRAM_NAME

Line 1692: JTY_DEA_ATTR_PRODUCTS_SQL_S.NEXTVAL

1688: ,REQUEST_ID
1689: ,PROGRAM_UPDATE_DATE
1690: ,BATCH_DEA_MATCH_SQL_WITH_TERR)
1691: VALUES(
1692: JTY_DEA_ATTR_PRODUCTS_SQL_S.NEXTVAL
1693: ,p_source_id
1694: ,p_trans_id
1695: ,l_pgm_name_tbl(i)
1696: ,p_qual_prd_tbl(j)