APPS.JTF_TTY_MAINTAIN_NA_PVT dependencies on JTF_TTY_ACCT_QUAL_MAPS

Line 302: DELETE from JTF_TTY_ACCT_QUAL_MAPS

298: where a.named_account_id = P_NAMED_ACCT_ID);
299:
300: --Delete the NA mappings if an NA is deleted or no reference to it exists
301:
302: DELETE from JTF_TTY_ACCT_QUAL_MAPS
303: WHERE named_account_id = P_NAMED_ACCT_ID
304: AND NOT EXISTS (SELECT named_account_id
305: from JTF_TTY_NAMED_ACCTS a
306: where a.named_account_id = P_NAMED_ACCT_ID); --Delete named account if it has no other TG references

Line 477: INSERT INTO jtf_tty_acct_qual_maps

473:
474: --Key name for business name
475: IF (l_business_name is not null) THEN
476:
477: INSERT INTO jtf_tty_acct_qual_maps
478: (ACCOUNT_QUAL_MAP_ID,
479: OBJECT_VERSION_NUMBER,
480: NAMED_ACCOUNT_ID,
481: QUAL_USG_ID,

Line 489: (SELECT jtf_tty_acct_qual_maps_s.nextval,

485: CREATED_BY,
486: CREATION_DATE,
487: LAST_UPDATED_BY,
488: LAST_UPDATE_DATE)
489: (SELECT jtf_tty_acct_qual_maps_s.nextval,
490: 1,
491: p_acct_id,
492: -1012,
493: '=',

Line 506: INSERT INTO jtf_tty_acct_qual_maps

502:
503: --Key name for trade name
504: IF (l_trade_name is not null) THEN
505:
506: INSERT INTO jtf_tty_acct_qual_maps
507: (ACCOUNT_QUAL_MAP_ID,
508: OBJECT_VERSION_NUMBER,
509: NAMED_ACCOUNT_ID,
510: QUAL_USG_ID,

Line 518: (SELECT jtf_tty_acct_qual_maps_s.nextval,

514: CREATED_BY,
515: CREATION_DATE,
516: LAST_UPDATED_BY,
517: LAST_UPDATE_DATE)
518: (SELECT jtf_tty_acct_qual_maps_s.nextval,
519: 1,
520: p_acct_id,
521: -1012,
522: '=',

Line 535: INSERT INTO jtf_tty_acct_qual_maps

531:
532: --Key name for postal code
533: IF (l_postal_code is not null) THEN
534:
535: INSERT INTO jtf_tty_acct_qual_maps
536: (ACCOUNT_QUAL_MAP_ID,
537: OBJECT_VERSION_NUMBER,
538: NAMED_ACCOUNT_ID,
539: QUAL_USG_ID,

Line 547: (SELECT jtf_tty_acct_qual_maps_s.nextval,

543: CREATED_BY,
544: CREATION_DATE,
545: LAST_UPDATED_BY,
546: LAST_UPDATE_DATE)
547: (SELECT jtf_tty_acct_qual_maps_s.nextval,
548: 1,
549: p_acct_id,
550: -1007,
551: '=',