DBA Data[Home] [Help]

APPS.JTF_RS_GROUPS_AUD_PVT dependencies on JTF_RS_GROUPS_VL

Line 166: FROM jtf_rs_groups_vl B

162: b.email_address,
163: b.group_name,
164: b.group_desc,
165: b.time_zone
166: FROM jtf_rs_groups_vl B
167: WHERE b.group_id = l_group_id;
168:
169:
170:

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

176: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
177: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
178: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
179: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
180: l_group_name JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;
181: l_group_desc JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;
182: l_time_zone JTF_RS_GROUPS_B.TIME_ZONE%TYPE;
183:
184:

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

177: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
178: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
179: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
180: l_group_name JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;
181: l_group_desc JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;
182: l_time_zone JTF_RS_GROUPS_B.TIME_ZONE%TYPE;
183:
184:
185:

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

192: l_end_date_active_n JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
193: l_accounting_code_n JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
194: l_object_version_number_n JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
195: l_email_address_n JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
196: l_group_name_n JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;
197: l_group_desc_n JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;
198: l_time_zone_n JTF_RS_GROUPS_B.TIME_ZONE%TYPE;
199:
200: rr_old_rec rr_old_cur%rowtype;

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

193: l_accounting_code_n JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
194: l_object_version_number_n JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
195: l_email_address_n JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
196: l_group_name_n JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;
197: l_group_desc_n JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;
198: l_time_zone_n JTF_RS_GROUPS_B.TIME_ZONE%TYPE;
199:
200: rr_old_rec rr_old_cur%rowtype;
201:

Line 381: FROM jtf_rs_groups_vl B

377: b.email_address,
378: b.group_name,
379: b.group_desc,
380: b.time_zone
381: FROM jtf_rs_groups_vl B
382: WHERE b.group_id = l_group_id;
383:
384:
385: --declare variables

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

390: l_end_date_active JTF_RS_GROUPS_B.END_DATE_ACTIVE%TYPE;
391: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
392: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
393: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
394: l_group_name JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;
395: l_group_desc JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;
396: l_time_zone JTF_RS_GROUPS_B.TIME_ZONE%TYPE;
397:
398: rr_old_rec rr_old_cur%rowtype;

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

391: l_accounting_code JTF_RS_GROUPS_B.ACCOUNTING_CODE%TYPE;
392: l_object_version_number JTF_RS_GROUPS_B.OBJECT_VERSION_NUMBER%TYPE;
393: l_email_address JTF_RS_GROUPS_B.EMAIL_ADDRESS%TYPE;
394: l_group_name JTF_RS_GROUPS_VL.GROUP_NAME%TYPE := null ;
395: l_group_desc JTF_RS_GROUPS_VL.GROUP_DESC%TYPE := null ;
396: l_time_zone JTF_RS_GROUPS_B.TIME_ZONE%TYPE;
397:
398: rr_old_rec rr_old_cur%rowtype;
399: