APPS.AMS_CUST_SETUP_PVT dependencies on AMS_SETUP_TYPES

Line 242: FROM ams_setup_types stp

238: nvl(stp.copy_allowed_flag,'N'),
239: stp.related_ak_attribute,
240: stp.essential_seq_num
241:
242: FROM ams_setup_types stp
243: WHERE stp.object_type = l_cust_setup_rec.object_type
244: AND stp.activity_type_code = l_cust_setup_rec.activity_type_code
245: AND (stp.usage ='ALL' OR stp.usage is null)
246: AND stp.application_id = l_cust_setup_rec.application_id;

Line 293: FROM ams_setup_types stp

289: nvl(stp.show_in_cue_card,'Y'),
290: nvl(stp.copy_allowed_flag,'N'),
291: stp.related_ak_attribute,
292: stp.essential_seq_num
293: FROM ams_setup_types stp
294: WHERE stp.object_type = l_cust_setup_rec.object_type
295: AND stp.activity_type_code is null
296: AND (stp.usage ='ALL' OR stp.usage is null)
297: AND stp.application_id = l_cust_setup_rec.application_id;

Line 351: FROM ams_setup_types stp

347: nvl(stp.copy_allowed_flag,'N'),
348: stp.related_ak_attribute,
349: stp.essential_seq_num
350:
351: FROM ams_setup_types stp
352: WHERE stp.object_type = l_cust_setup_rec.object_type
353: AND stp.activity_type_code = l_cust_setup_rec.activity_type_code
354: AND stp.usage in ('LITE','ALL')
355: AND stp.application_id = l_cust_setup_rec.application_id

Line 406: FROM ams_setup_types stp

402: nvl(stp.show_in_cue_card,'Y'),
403: nvl(stp.copy_allowed_flag,'N'),
404: stp.related_ak_attribute,
405: stp.essential_seq_num
406: FROM ams_setup_types stp
407: WHERE stp.object_type = l_cust_setup_rec.object_type
408: AND stp.activity_type_code is null
409: AND stp.usage in ('LITE','ALL')
410: AND stp.application_id = l_cust_setup_rec.application_id

Line 464: FROM ams_setup_types stp

460: nvl(stp.copy_allowed_flag,'N'),
461: stp.related_ak_attribute,
462: stp.essential_seq_num
463:
464: FROM ams_setup_types stp
465: WHERE stp.object_type = l_cust_setup_rec.object_type
466: AND stp.activity_type_code = l_cust_setup_rec.activity_type_code
467: AND stp.usage in ('LITE','ALL')
468: AND stp.application_id = l_cust_setup_rec.application_id;

Line 518: FROM ams_setup_types stp

514: nvl(stp.show_in_cue_card,'Y'),
515: nvl(stp.copy_allowed_flag,'N'),
516: stp.related_ak_attribute,
517: stp.essential_seq_num
518: FROM ams_setup_types stp
519: WHERE stp.object_type = l_cust_setup_rec.object_type
520: AND stp.activity_type_code is null
521: AND stp.usage in ('LITE','ALL')
522: AND stp.application_id = l_cust_setup_rec.application_id;