DBA Data[Home] [Help]

APPS.IGS_PR_CP_GPA dependencies on IGS_CA_LOAD_TO_TEACH_V

Line 1953: FROM igs_ca_load_to_teach_v ltt1

1949: AND ci1.cal_type = sua.cal_type
1950: AND ci1.sequence_number = sua.ci_sequence_number
1951: AND ( ( p_cumulative_ind = 'N'
1952: AND EXISTS ( SELECT 'X'
1953: FROM igs_ca_load_to_teach_v ltt1
1954: WHERE p_load_cal_type = ltt1.load_cal_type
1955: AND p_load_ci_sequence_number =
1956: ltt1.load_ci_sequence_number
1957: AND sua.cal_type = ltt1.teach_cal_type

Line 1963: FROM igs_ca_inst ci2, igs_ca_load_to_teach_v ltt2

1959: ltt1.teach_ci_sequence_number)
1960: )
1961: OR ( p_cumulative_ind = 'Y'
1962: AND EXISTS ( SELECT 'X'
1963: FROM igs_ca_inst ci2, igs_ca_load_to_teach_v ltt2
1964: WHERE ci2.cal_type = p_load_cal_type
1965: AND ci2.sequence_number =
1966: p_load_ci_sequence_number
1967: AND sua.cal_type = ltt2.teach_cal_type