eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_GROUPS_AUD_PVT dependencies on JTF_RS_GROUPS_VL

Line 161: FROM jtf_rs_groups_vl B

157: b.object_version_number,
158: b.email_address,
159: b.group_name,
160: b.group_desc
161: FROM jtf_rs_groups_vl B
162: WHERE b.group_id = l_group_id;
163:
164:
165:

Line 175: l_group_name JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;

171: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
172: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
173: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
174: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
175: l_group_name JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;
176: l_group_desc JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;
177:
178:
179:

Line 176: l_group_desc JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;

172: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
173: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
174: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
175: l_group_name JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;
176: l_group_desc JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;
177:
178:
179:
180:

Line 190: l_group_name_n JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;

186: l_end_date_active_n JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
187: l_accounting_code_n JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
188: l_object_version_number_n JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
189: l_email_address_n JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
190: l_group_name_n JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;
191: l_group_desc_n JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;
192:
193:
194: rr_old_rec rr_old_cur%rowtype;

Line 191: l_group_desc_n JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;

187: l_accounting_code_n JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
188: l_object_version_number_n JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
189: l_email_address_n JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
190: l_group_name_n JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;
191: l_group_desc_n JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;
192:
193:
194: rr_old_rec rr_old_cur%rowtype;
195:

Line 367: FROM jtf_rs_groups_vl B

363: b.object_version_number,
364: b.email_address,
365: b.group_name,
366: b.group_desc
367: FROM jtf_rs_groups_vl B
368: WHERE b.group_id = l_group_id;
369:
370:
371: --declare variables

Line 380: l_group_name JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;

376: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
377: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
378: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
379: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
380: l_group_name JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;
381: l_group_desc JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;
382:
383: rr_old_rec rr_old_cur%rowtype;
384:

Line 381: l_group_desc JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;

377: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
378: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
379: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
380: l_group_name JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;
381: l_group_desc JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;
382:
383: rr_old_rec rr_old_cur%rowtype;
384:
385: l_group_audit_id jtf_rs_groups_aud_b.group_audit_id%type;