APPS.AHL_MEL_CDL_ATA_SEQS_PVT dependencies on AHL_MEL_CDL_ATA_SEQUENCES_V

Line 1283: ahl_mel_cdl_ata_sequences_v a,

1279: )
1280: IS
1281: SELECT 'x'
1282: FROM
1283: ahl_mel_cdl_ata_sequences_v a,
1284: ahl_mel_cdl_ata_sequences_v b
1285: WHERE
1286: a.mel_cdl_ata_sequence_id= p_ata_seq_id
1287: AND b.mel_cdl_ata_sequence_id = p_rel_ata_seq_id

Line 1284: ahl_mel_cdl_ata_sequences_v b

1280: IS
1281: SELECT 'x'
1282: FROM
1283: ahl_mel_cdl_ata_sequences_v a,
1284: ahl_mel_cdl_ata_sequences_v b
1285: WHERE
1286: a.mel_cdl_ata_sequence_id= p_ata_seq_id
1287: AND b.mel_cdl_ata_sequence_id = p_rel_ata_seq_id
1288: AND a.mel_cdl_header_id = b.mel_cdl_header_id;

Line 1453: ahl_mel_cdl_ata_sequences_v

1449:
1450: --Get the ATA Meaning for ATA Sequence Id
1451: SELECT ata_meaning INTO l_ata_mng
1452: FROM
1453: ahl_mel_cdl_ata_sequences_v
1454: WHERE
1455: mel_cdl_ata_sequence_id = p_x_ata_relations_tbl(l_rec_idx).ata_sequence_id;
1456:
1457: --Get the ATA Meaning for Related ATA Sequence Id

Line 1460: ahl_mel_cdl_ata_sequences_v

1456:
1457: --Get the ATA Meaning for Related ATA Sequence Id
1458: SELECT ata_meaning INTO l_reln_ata_mng
1459: FROM
1460: ahl_mel_cdl_ata_sequences_v
1461: WHERE
1462: mel_cdl_ata_sequence_id = p_x_ata_relations_tbl(l_rec_idx).related_ata_sequence_id;
1463:
1464: -- Check if the Relationship already Exists (ie, ata_sequence_id is associated to related_ata_sequence_id)