APPS.AMV_PERSPECTIVE_PVT dependencies on AMV_I_PERSPECTIVES_TL

Line 21: From amv_i_perspectives_tl

17: ----------------------------- Private Cursors in this package ------------------
18: CURSOR Check_DupPerspectName_csr(p_name IN varchar2) IS
19: Select
20: perspective_id
21: From amv_i_perspectives_tl
22: Where perspective_name = p_name
23: And language IN
24: (
25: Select L.language_code

Line 34: From amv_i_perspectives_tl

30: --
31: CURSOR Check_ValidPerspectName_csr(p_name varchar2) IS
32: Select
33: perspective_id
34: From amv_i_perspectives_tl
35: Where perspective_name = p_name
36: And language = userenv('lang');
37: --
38: --------------------------- Private Utility inside this package ----------------

Line 633: From AMV_I_PERSPECTIVES_TL T, AMV_I_PERSPECTIVES_B B

629: B.CREATED_BY,
630: B.LAST_UPDATE_DATE,
631: B.LAST_UPDATED_BY,
632: B.LAST_UPDATE_LOGIN
633: From AMV_I_PERSPECTIVES_TL T, AMV_I_PERSPECTIVES_B B
634: Where B.PERSPECTIVE_ID = T.PERSPECTIVE_ID
635: And T.LANGUAGE = userenv('LANG')
636: And B.PERSPECTIVE_ID = p_ID;
637: --

Line 892: 'From AMV_I_PERSPECTIVES_TL T, AMV_I_PERSPECTIVES_B B ';

888: 'B.CREATED_BY, ' ||
889: 'B.LAST_UPDATE_DATE, ' ||
890: 'B.LAST_UPDATED_BY, ' ||
891: 'B.LAST_UPDATE_LOGIN ' ||
892: 'From AMV_I_PERSPECTIVES_TL T, AMV_I_PERSPECTIVES_B B ';
893: l_sql_statement2 :=
894: 'Select count(*) ' ||
895: 'From AMV_I_PERSPECTIVES_TL T, AMV_I_PERSPECTIVES_B B ';
896: --

Line 895: 'From AMV_I_PERSPECTIVES_TL T, AMV_I_PERSPECTIVES_B B ';

891: 'B.LAST_UPDATE_LOGIN ' ||
892: 'From AMV_I_PERSPECTIVES_TL T, AMV_I_PERSPECTIVES_B B ';
893: l_sql_statement2 :=
894: 'Select count(*) ' ||
895: 'From AMV_I_PERSPECTIVES_TL T, AMV_I_PERSPECTIVES_B B ';
896: --
897: l_where_clause :=
898: 'Where B.PERSPECTIVE_ID = T.PERSPECTIVE_ID ' ||
899: 'And T.LANGUAGE = userenv(''LANG'') ';

Line 1852: From AMV_I_PERSPECTIVES_TL T, AMV_I_PERSPECTIVES_B B,

1848: B.CREATED_BY,
1849: B.LAST_UPDATE_DATE,
1850: B.LAST_UPDATED_BY,
1851: B.LAST_UPDATE_LOGIN
1852: From AMV_I_PERSPECTIVES_TL T, AMV_I_PERSPECTIVES_B B,
1853: AMV_I_ITEM_PERSPECTIVES I
1854: Where B.PERSPECTIVE_ID = I.PERSPECTIVE_ID
1855: And T.PERSPECTIVE_ID = I.PERSPECTIVE_ID
1856: And T.LANGUAGE = userenv('LANG')