APPS.IGS_FI_PRC_REFUNDS dependencies on IGS_LOOKUPS_VIEW

Line 115: FROM igs_lookups_view

111: --
112: CURSOR cur_lkp(cp_lookup_type VARCHAR2,
113: cp_lookup_code VARCHAR2) IS
114: SELECT meaning
115: FROM igs_lookups_view
116: WHERE lookup_type = cp_lookup_type
117: AND lookup_code = cp_lookup_code;
118:
119: l_meaning igs_lookups_view.meaning%TYPE;

Line 119: l_meaning igs_lookups_view.meaning%TYPE;

115: FROM igs_lookups_view
116: WHERE lookup_type = cp_lookup_type
117: AND lookup_code = cp_lookup_code;
118:
119: l_meaning igs_lookups_view.meaning%TYPE;
120: BEGIN
121: -- Fetch the meaning from the Lookups table
122: OPEN cur_lkp(p_lookup_type,
123: p_lookup_code);

Line 146: l_meaning igs_lookups_view.meaning%TYPE;

142: Who When What
143:
144: ********************************************************************************************** */
145:
146: l_meaning igs_lookups_view.meaning%TYPE;
147: l_message varchar2(2000);
148: BEGIN
149:
150: l_meaning := get_meaning(p_lookup_type,

Line 301: l_determination igs_lookups_view.lookup_code%TYPE;

297: l_application_id igs_fi_applications.application_id%TYPE;
298: l_payee_id igs_fi_parties_v.person_id%TYPE;
299: l_reason fnd_new_messages.message_text%TYPE;
300: l_party_id igs_fi_parties_v.person_id%TYPE;
301: l_determination igs_lookups_view.lookup_code%TYPE;
302: l_credit_type_id igs_fi_cr_types.credit_type_id%TYPE;
303: l_effective_date igs_fi_credits.effective_date%TYPE;
304:
305: -- Varchar2 variables

Line 793: l_determination igs_lookups_view.lookup_code%TYPE;

789: l_application_id igs_fi_applications.application_id%TYPE;
790: l_payee_id igs_fi_parties_v.person_id%TYPE;
791: l_reason fnd_new_messages.message_text%TYPE;
792: l_err_msg fnd_new_messages.message_name%TYPE;
793: l_determination igs_lookups_view.lookup_code%TYPE;
794: l_fee_type igs_fi_fee_type.fee_type%TYPE;
795: l_fee_cal_type igs_ca_inst.cal_type%TYPE;
796: l_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
797: l_rfnd_amnt igs_fi_refunds.refund_amount%TYPE;