DBA Data[Home] [Help]

APPS.JTF_TTY_NA_TERRGP dependencies on JTF_TTY_TERR_GRP_ACCTS_S

Line 3021: SELECT JTF_TTY_TERR_GRP_ACCTS_S.NEXTVAL

3017: AND tna.party_id = p_party_id;
3018: x_gp_acct_id := p_terr_gp_acct_id;
3019: END IF;
3020:
3021: SELECT JTF_TTY_TERR_GRP_ACCTS_S.NEXTVAL
3022: INTO p_terr_gp_acct_id
3023: FROM dual;
3024:
3025: -- assign a named account for the party to terr gp, if one does not exist

Line 3126: SELECT JTF_TTY_TERR_GRP_ACCTS_S.NEXTVAL

3122: FROM JTF_TTY_TERR_GRP_ACCTS tga, JTF_TTY_NAMED_ACCTS tna
3123: WHERE tga.named_account_id = tna.named_account_id
3124: AND tna.party_id = p_party_id;
3125:
3126: SELECT JTF_TTY_TERR_GRP_ACCTS_S.NEXTVAL
3127: INTO p_terr_gp_acct_id
3128: FROM dual;
3129: -- assign a named account for the party to terr gp, if one does not exist
3130: