APPS.JTY_TAE_GEN_PVT dependencies on JTY_DEA_ATTR_PRODUCTS_SQL

Line 1609: FROM jty_dea_attr_products_sql

1605:
1606: IF (p_mode = 'DATE EFFECTIVE') THEN
1607: SELECT count(*)
1608: INTO l_no_of_records
1609: FROM jty_dea_attr_products_sql
1610: WHERE source_id = p_source_id
1611: AND trans_type_id = p_trans_id
1612: AND program_name = l_pgm_name_tbl(i)
1613: AND attr_relation_product = p_qual_prd_tbl(j);

Line 1744: INSERT INTO JTY_DEA_ATTR_PRODUCTS_SQL(

1740: ,G_SYSDATE
1741: );
1742:
1743: ELSE
1744: INSERT INTO JTY_DEA_ATTR_PRODUCTS_SQL(
1745: DEA_ATTR_PRODUCTS_SQL_ID
1746: ,SOURCE_ID
1747: ,TRANS_TYPE_ID
1748: ,PROGRAM_NAME

Line 1763: JTY_DEA_ATTR_PRODUCTS_SQL_S.NEXTVAL

1759: ,PROGRAM_APPLICATION_ID
1760: ,REQUEST_ID
1761: ,PROGRAM_UPDATE_DATE)
1762: VALUES(
1763: JTY_DEA_ATTR_PRODUCTS_SQL_S.NEXTVAL
1764: ,p_source_id
1765: ,p_trans_id
1766: ,l_pgm_name_tbl(i)
1767: ,p_qual_prd_tbl(j)