APPS.IGS_EN_TRANSFER_APIS dependencies on IGS_AV_ADV_STANDING

Line 1392: CURSOR c_is_adv_st_exists(c_person_id IGS_AV_ADV_STANDING.PERSON_ID%TYPE,

1388:
1389: l_val VARCHAR2(1);
1390: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
1391:
1392: CURSOR c_is_adv_st_exists(c_person_id IGS_AV_ADV_STANDING.PERSON_ID%TYPE,
1393: c_source_program_cd IGS_AV_ADV_STANDING.COURSE_CD%TYPE,
1394: c_source_prog_ver IGS_AV_ADV_STANDING.VERSION_NUMBER%TYPE )IS
1395: SELECT 'x'
1396: FROM IGS_AV_ADV_STANDING

Line 1393: c_source_program_cd IGS_AV_ADV_STANDING.COURSE_CD%TYPE,

1389: l_val VARCHAR2(1);
1390: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
1391:
1392: CURSOR c_is_adv_st_exists(c_person_id IGS_AV_ADV_STANDING.PERSON_ID%TYPE,
1393: c_source_program_cd IGS_AV_ADV_STANDING.COURSE_CD%TYPE,
1394: c_source_prog_ver IGS_AV_ADV_STANDING.VERSION_NUMBER%TYPE )IS
1395: SELECT 'x'
1396: FROM IGS_AV_ADV_STANDING
1397: WHERE person_id = c_person_id AND

Line 1394: c_source_prog_ver IGS_AV_ADV_STANDING.VERSION_NUMBER%TYPE )IS

1390: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
1391:
1392: CURSOR c_is_adv_st_exists(c_person_id IGS_AV_ADV_STANDING.PERSON_ID%TYPE,
1393: c_source_program_cd IGS_AV_ADV_STANDING.COURSE_CD%TYPE,
1394: c_source_prog_ver IGS_AV_ADV_STANDING.VERSION_NUMBER%TYPE )IS
1395: SELECT 'x'
1396: FROM IGS_AV_ADV_STANDING
1397: WHERE person_id = c_person_id AND
1398: course_cd = c_source_program_cd AND

Line 1396: FROM IGS_AV_ADV_STANDING

1392: CURSOR c_is_adv_st_exists(c_person_id IGS_AV_ADV_STANDING.PERSON_ID%TYPE,
1393: c_source_program_cd IGS_AV_ADV_STANDING.COURSE_CD%TYPE,
1394: c_source_prog_ver IGS_AV_ADV_STANDING.VERSION_NUMBER%TYPE )IS
1395: SELECT 'x'
1396: FROM IGS_AV_ADV_STANDING
1397: WHERE person_id = c_person_id AND
1398: course_cd = c_source_program_cd AND
1399: version_number = c_source_prog_ver;
1400: