APPS.AHL_MEL_CDL_ATA_SEQS_PVT dependencies on AHL_MEL_CDL_ATA_SEQUENCES_V

Line 1289: ahl_mel_cdl_ata_sequences_v a,

1285: )
1286: IS
1287: SELECT 'x'
1288: FROM
1289: ahl_mel_cdl_ata_sequences_v a,
1290: ahl_mel_cdl_ata_sequences_v b
1291: WHERE
1292: a.mel_cdl_ata_sequence_id= p_ata_seq_id
1293: AND b.mel_cdl_ata_sequence_id = p_rel_ata_seq_id

Line 1290: ahl_mel_cdl_ata_sequences_v b

1286: IS
1287: SELECT 'x'
1288: FROM
1289: ahl_mel_cdl_ata_sequences_v a,
1290: ahl_mel_cdl_ata_sequences_v b
1291: WHERE
1292: a.mel_cdl_ata_sequence_id= p_ata_seq_id
1293: AND b.mel_cdl_ata_sequence_id = p_rel_ata_seq_id
1294: AND a.mel_cdl_header_id = b.mel_cdl_header_id;

Line 1459: ahl_mel_cdl_ata_sequences_v

1455:
1456: --Get the ATA Meaning for ATA Sequence Id
1457: SELECT ata_meaning INTO l_ata_mng
1458: FROM
1459: ahl_mel_cdl_ata_sequences_v
1460: WHERE
1461: mel_cdl_ata_sequence_id = p_x_ata_relations_tbl(l_rec_idx).ata_sequence_id;
1462:
1463: --Get the ATA Meaning for Related ATA Sequence Id

Line 1466: ahl_mel_cdl_ata_sequences_v

1462:
1463: --Get the ATA Meaning for Related ATA Sequence Id
1464: SELECT ata_meaning INTO l_reln_ata_mng
1465: FROM
1466: ahl_mel_cdl_ata_sequences_v
1467: WHERE
1468: mel_cdl_ata_sequence_id = p_x_ata_relations_tbl(l_rec_idx).related_ata_sequence_id;
1469:
1470: -- Check if the Relationship already Exists (ie, ata_sequence_id is associated to related_ata_sequence_id)