DBA Data[Home] [Help]

APPS.IGS_DA_XML_PKG dependencies on IGS_DA_REQ_WIF

Line 1076: FROM igs_da_req_wif drw

1072: WHERE drs.batch_id = RTRIM(LTRIM(p_batch_id))
1073: AND drs.person_id = l_person_id
1074: AND drs.program_major_code = RTRIM(LTRIM(p_program_code))
1075: AND EXISTS (SELECT 'X'
1076: FROM igs_da_req_wif drw
1077: WHERE drw.batch_id = drs.batch_id
1078: AND drw.wif_id = drs.wif_id
1079: AND drw.program_code = drs.wif_program_code
1080: AND drw.major_unit_set_cd1 = drs.major_unit_set_cd

Line 1121: FROM igs_da_req_wif drw

1117: WHERE drs.batch_id = RTRIM(LTRIM(p_batch_id))
1118: AND drs.person_id = l_person_id
1119: AND drs.wif_program_code = RTRIM(LTRIM(p_program_code))
1120: AND exists (SELECT 'X'
1121: FROM igs_da_req_wif drw
1122: WHERE drw.batch_id = drs.batch_id
1123: AND drw.wif_id = drs.wif_id
1124: AND drw.program_code = drs.wif_program_code
1125: AND (drw.major_unit_set_cd1 = RTRIM(LTRIM(l_academicsubprogramcode1))