APPS.IGS_FI_PRC_REFUNDS dependencies on IGS_FI_CR_TYPES

Line 63: credit_class IGS_FI_CR_TYPES.Credit_Class%TYPE,

59: PRAGMA EXCEPTION_INIT(e_resource_busy,-0054);
60:
61: -- PL/SQL record for the Credit Information
62: TYPE crdrec IS RECORD(credit_id IGS_FI_CREDITS.Credit_Id%TYPE,
63: credit_class IGS_FI_CR_TYPES.Credit_Class%TYPE,
64: unapplied_amount IGS_FI_CREDITS.Unapplied_Amount%TYPE,
65: fee_type IGS_FI_FEE_TYPE.Fee_Type%TYPE,
66: fee_cal_type IGS_CA_INST.Cal_Type%TYPE,
67: fee_ci_sequence_number IGS_CA_INST.Sequence_Number%TYPE,

Line 253: igs_fi_cr_types crt

249: SELECT crd.party_id,
250: crd.credit_type_id,
251: crd.effective_date
252: FROM igs_fi_credits crd,
253: igs_fi_cr_types crt
254: WHERE crd.credit_id = cp_credit_id
255: AND crd.credit_type_id = crt.credit_type_id
256: AND crd.status = cp_status
257: AND NVL(crt.refund_allowed,g_ind_no) = g_ind_yes;

Line 273: CURSOR cur_appl_hier(cp_credit_type_id igs_fi_cr_types.credit_type_id%TYPE,

269: AND crd.status = cp_status
270: FOR UPDATE NOWAIT;
271:
272: -- Cursor for fetching the Application Hierarchy for the Credit Type
273: CURSOR cur_appl_hier(cp_credit_type_id igs_fi_cr_types.credit_type_id%TYPE,
274: cp_effective_date igs_fi_credits.effective_date%TYPE) IS
275: SELECT 'x'
276: FROM igs_fi_a_hierarchies
277: WHERE credit_type_id = cp_credit_type_id

Line 302: l_credit_type_id igs_fi_cr_types.credit_type_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
306: l_err_msg VARCHAR2(2000);

Line 704: igs_fi_cr_types crt

700: -- processed if no person id given
701: CURSOR cur_party_all IS
702: SELECT DISTINCT crd.party_id person_id
703: FROM igs_fi_credits crd,
704: igs_fi_cr_types crt
705: WHERE crd.credit_type_id = crt.credit_type_id
706: AND crd.status = g_cleared
707: AND NVL(crt.refund_allowed,g_ind_no) = g_ind_yes
708: AND crd.unapplied_amount > 0;

Line 725: igs_fi_cr_types crt,

721: cp_status igs_fi_credits.status%TYPE
722: ) IS
723: SELECT crd.*, crt.credit_class
724: FROM igs_fi_credits crd,
725: igs_fi_cr_types crt,
726: igs_fi_cr_activities cra
727: WHERE crd.credit_type_id = crt.credit_type_id
728: AND crd.status = cp_status
729: AND crd.party_id = cp_person_id