APPS.JTF_TTY_NA_WF dependencies on JTF_TTY_ACCT_RSC_DN

Line 428: INSERT INTO jtf_tty_acct_rsc_dn

424: );
425:
426: --Insert into denorm table, the resource hierarchy records (similar to those of the candidate resource territory)
427: -- ARPATEL 01/30/03
428: INSERT INTO jtf_tty_acct_rsc_dn
429: (ACCOUNT_RESOURCE_DN_ID,
430: OBJECT_VERSION_NUMBER ,
431: TERR_GROUP_ACCOUNT_ID,
432: RESOURCE_ID ,

Line 443: SELECT jtf_tty_acct_rsc_dn_s.nextval,

439: LAST_UPDATED_BY ,
440: LAST_UPDATE_DATE ,
441: LAST_UPDATE_LOGIN
442: )
443: SELECT jtf_tty_acct_rsc_dn_s.nextval,
444: 1.0 ,
445: p_terr_gp_acct_id,
446: RESOURCE_ID ,
447: RSC_GROUP_ID,

Line 456: FROM jtf_tty_acct_rsc_dn

452: sysdate,
453: p_user_id,
454: sysdate,
455: p_user_id
456: FROM jtf_tty_acct_rsc_dn
457: WHERE terr_group_account_id = (select TGA.terr_group_account_id
458: from JTF_TTY_TERR_GRP_ACCTS TGA
459: where TGA.named_account_id = p_ref_account_id
460: and TGA.terr_group_id = p_terr_gp_id);