APPS.CN_SCA_CREDITS_BATCH_PUB dependencies on JTY_CONC_REQ_SUMM

Line 967: FROM jty_conc_req_summ jcrs, jty_changed_dea_terrs jcdt

963: AND adjust_status NOT IN(''FROZEN'', ''REVERSAL'')
964: START WITH COMM_LINES_API_ID IN (SELECT adj_comm_lines_api_id from cn_comm_lines_api_all
965: WHERE terr_id IN (
966: SELECT jcdt.terr_id
967: FROM jty_conc_req_summ jcrs, jty_changed_dea_terrs jcdt
968: WHERE jcrs.program_name = ''JTY_STAR''
969: AND jcrs.retcode = 0
970: AND jcrs.param1 = -1001
971: AND jcrs.param2 = ''DEA INCREMENTAL''

Line 1608: FROM jty_conc_req_summ a

1604:
1605: IF( p_run_mode = 'INCREMENTAL' ) THEN
1606: SELECT count(*)
1607: INTO l_count
1608: FROM jty_conc_req_summ a
1609: WHERE a.program_name = 'JTY_STAR'
1610: AND a.param1 = -1001
1611: AND a.param2 = 'DEA INCREMENTAL'
1612: AND a.retcode = 0;

Line 1626: FROM jty_conc_req_summ a

1622: l_count := 0;
1623:
1624: SELECT count(*)
1625: INTO l_count
1626: FROM jty_conc_req_summ a
1627: WHERE a.program_name = 'JTY_STAR'
1628: AND a.param1 = -1001
1629: AND a.retcode = 0
1630: AND a.param2 = 'DATE EFFECTIVE'

Line 1632: FROM jty_conc_req_summ a

1628: AND a.param1 = -1001
1629: AND a.retcode = 0
1630: AND a.param2 = 'DATE EFFECTIVE'
1631: AND request_date > ( SELECT MAX(request_date)
1632: FROM jty_conc_req_summ a
1633: WHERE a.program_name = 'JTY_STAR'
1634: AND a.retcode = 0
1635: AND a.param1 = -1001
1636: AND a.param2 = 'DEA INCREMENTAL' );