APPS.IGS_AD_INT_RECONSIDER dependencies on IGS_AD_CODE_CLASSES

Line 1023: igs_ad_code_classes ccl , igs_lookup_values lkup

1019: CURSOR c_fee_status IS
1020: SELECT
1021: ccl.code_id
1022: FROM
1023: igs_ad_code_classes ccl , igs_lookup_values lkup
1024: WHERE
1025: ccl.system_status = lkup.lookup_code
1026: AND lkup.lookup_type = 'SYS_FEE_STATUS'
1027: AND ccl.system_status = 'WAIVED'

Line 1407: p_dec_reason_id IGS_AD_CODE_CLASSES.code_id%TYPE

1403: p_group_id igs_pe_persid_group.group_id%TYPE,
1404: p_application_id NUMBER,
1405: p_decision_date VARCHAR2,
1406: p_dec_maker_id igs_pe_person_base_v.person_id%TYPE,
1407: p_dec_reason_id IGS_AD_CODE_CLASSES.code_id%TYPE
1408: ) IS
1409: /*******************************************************************************
1410: Created by : Rishi Ghosh
1411: Date created: 12 September 2005