DBA Data[Home] [Help]

APPS.JTY_TERR_ENGINE_GEN_PVT dependencies on JTY_TRANS_USG_PGM_DETAILS

Line 1200: FROM jty_trans_usg_pgm_details a

1196: /* if batch mode is not enabled for the usage, delete all the entries processed from the changed table */
1197: IF ((p_mode = 'TOTAL') OR (p_mode = 'INCREMENTAL')) THEN
1198: SELECT count(*)
1199: INTO l_batch_enabled
1200: FROM jty_trans_usg_pgm_details a
1201: WHERE a.source_id = p_source_id
1202: AND a.batch_enable_flag = 'Y';
1203:
1204: IF (l_batch_enabled = 0) THEN

Line 1211: FROM jty_trans_usg_pgm_details a

1207: END IF;
1208: ELSIF (p_mode = 'DEA INCREMENTAL') THEN
1209: SELECT count(*)
1210: INTO l_batch_enabled
1211: FROM jty_trans_usg_pgm_details a
1212: WHERE a.source_id = p_source_id
1213: AND a.batch_enable_flag = 'Y';
1214:
1215: IF (l_batch_enabled = 0) THEN