DBA Data[Home] [Help]

APPS.JTF_TTY_NACCT_SALES_PUB dependencies on HZ_RELATIONSHIPS

Line 147: from hz_relationships hzr,

143: -- ALL SUBSIDIARIES OF cl_party_id that is owned by lp_user_resource_id, p_terr_group_id
144: -- QUERY MODIFIED FOR TERR_GROUP_ACCOUNT_ID IN/OUT
145: cursor c_subsidiaries(cl_terr_group_account_id number) is
146: select distinct gao.terr_group_account_id
147: from hz_relationships hzr,
148: jtf_tty_named_accts nai,
149: jtf_tty_terr_grp_accts gai,
150: jtf_tty_named_accts nao,
151: jtf_tty_terr_grp_accts gao