APPS.AMV_PERSPECTIVE_PVT dependencies on AMV_I_PERSPECTIVES_B

Line 72: AMV_I_PERSPECTIVES_B_S.nextval, sysdate

68: l_current_date date;
69: --
70: CURSOR Get_DateAndId_csr IS
71: select
72: AMV_I_PERSPECTIVES_B_S.nextval, sysdate
73: from dual;
74: --
75: BEGIN
76: -- Standard call to check for call compatibility.

Line 422: from Amv_i_perspectives_b

418: --
419: CURSOR Get_Version_csr(p_persp_id IN NUMBER) IS
420: Select
421: object_version_number
422: from Amv_i_perspectives_b
423: where perspective_id = p_persp_id;
424: --
425: --
426: BEGIN

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')