DBA Data[Home] [Help]

APPS.JTF_TTY_NA_TERRGP dependencies on JTF_TTY_NAMED_ACCTS_S

Line 2959: SELECT JTF_TTY_NAMED_ACCTS_S.NEXTVAL

2955: -- create a new named account for the party, if one does not exist
2956: -- create postal code and customer key names for a new account 2780737
2957: IF (p_account_count < 1) THEN
2958:
2959: SELECT JTF_TTY_NAMED_ACCTS_S.NEXTVAL
2960: INTO p_account_id
2961: FROM dual;
2962: INSERT INTO jtf_tty_named_accts
2963: (NAMED_ACCOUNT_ID,

Line 3085: SELECT JTF_TTY_NAMED_ACCTS_S.NEXTVAL

3081: FROM jtf_tty_named_accts
3082:
3083: WHERE party_id = p_party_id;
3084: -- create a new named account for the party, if one does not exist
3085: SELECT JTF_TTY_NAMED_ACCTS_S.NEXTVAL
3086: INTO p_account_id
3087: FROM dual;
3088:
3089: p_site_type_code := get_site_type_code(p_party_id);