APPS.JTY_TERR_ENGINE_GEN2_PVT dependencies on JTY_DEA_VALUES_IDX_HEADER

Line 601: FROM jty_dea_values_idx_header

597: l_no_of_records := 0;
598:
599: SELECT count(*)
600: INTO l_no_of_records
601: FROM jty_dea_values_idx_header
602: WHERE source_id = p_source_id
603: AND qual_usg_id = p_qual_usg_id_tbl(i);
604:
605: IF (l_no_of_records = 0) THEN

Line 607: SELECT jty_dea_values_idx_header_s.nextval

603: AND qual_usg_id = p_qual_usg_id_tbl(i);
604:
605: IF (l_no_of_records = 0) THEN
606:
607: SELECT jty_dea_values_idx_header_s.nextval
608: INTO l_header_seq
609: FROM dual;
610:
611: INSERT INTO jty_dea_values_idx_header (

Line 611: INSERT INTO jty_dea_values_idx_header (

607: SELECT jty_dea_values_idx_header_s.nextval
608: INTO l_header_seq
609: FROM dual;
610:
611: INSERT INTO jty_dea_values_idx_header (
612: dea_values_idx_header_id
613: ,source_id
614: ,last_update_date
615: ,last_updated_by

Line 1015: UPDATE jty_dea_values_idx_header

1011:
1012: /* in incremental mode , if the qualifier is alreday present */
1013: /* then mark it as being used by active territory */
1014: IF (p_mode = 'DEA INCREMENTAL') THEN
1015: UPDATE jty_dea_values_idx_header
1016: SET delete_flag = 'N'
1017: WHERE source_id = p_source_id
1018: AND qual_usg_id = p_qual_usg_id_tbl(i);
1019: END IF; -- END IF (p_mode = 'DEA INCREMENTAL')