eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_PRC_REFUNDS dependencies on IGS_FI_PARTIES_V

Line 298: l_payee_id igs_fi_parties_v.person_id%TYPE;

294: l_cr_acc_cd igs_fi_refunds.cr_account_cd%TYPE;
295: l_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;
296: l_unapp_amount igs_fi_credits.unapplied_amount%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;

Line 300: l_party_id igs_fi_parties_v.person_id%TYPE;

296: l_unapp_amount igs_fi_credits.unapplied_amount%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:

Line 679: CURSOR cur_val_party(cp_party_id IN igs_fi_parties_v.person_id%TYPE) IS

675:
676: ********************************************************************************************** */
677:
678: -- Cursor for validating the person id
679: CURSOR cur_val_party(cp_party_id IN igs_fi_parties_v.person_id%TYPE) IS
680: SELECT person_number
681: FROM igs_fi_parties_v pe
682: WHERE pe.person_id = cp_party_id;
683:

Line 681: FROM igs_fi_parties_v pe

677:
678: -- Cursor for validating the person id
679: CURSOR cur_val_party(cp_party_id IN igs_fi_parties_v.person_id%TYPE) IS
680: SELECT person_number
681: FROM igs_fi_parties_v pe
682: WHERE pe.person_id = cp_party_id;
683:
684: -- Cursor for validating the Person Id Group
685: CURSOR cur_pers(cp_person_id_grp igs_pe_persid_group.group_id%TYPE) IS

Line 694: CURSOR cur_party(cp_person_id igs_fi_parties_v.person_id%TYPE) IS

690:
691: -- Cursor for getting the Person Ids for which the Refunds have to be
692: -- processed
693: -- Bug 5018036 - Cursor cur_party broken into cur_party and cur_party_all.
694: CURSOR cur_party(cp_person_id igs_fi_parties_v.person_id%TYPE) IS
695: SELECT party_id person_id
696: FROM hz_parties
697: WHERE party_id = cp_person_id;
698:

Line 711: CURSOR cur_spnsr(cp_person_id igs_fi_parties_v.person_id%TYPE) IS

707: AND NVL(crt.refund_allowed,g_ind_no) = g_ind_yes
708: AND crd.unapplied_amount > 0;
709:
710: -- Cursor for validating whether the Person being processed is not a sponsor
711: CURSOR cur_spnsr(cp_person_id igs_fi_parties_v.person_id%TYPE) IS
712: SELECT 'x'
713: FROM igf_aw_fund_mast fund,
714: igf_aw_fund_cat fcat
715: WHERE fund.fund_code = fcat.fund_code

Line 720: CURSOR cur_crd(cp_person_id igs_fi_parties_v.person_id%TYPE,

716: AND fcat.sys_fund_type = g_sponsor
717: AND fund.party_id = cp_person_id;
718:
719: -- Cursor for getting the credit records for the Person Id
720: CURSOR cur_crd(cp_person_id igs_fi_parties_v.person_id%TYPE,
721: cp_status igs_fi_credits.status%TYPE
722: ) IS
723: SELECT crd.*, crt.credit_class
724: FROM igs_fi_credits crd,

Line 737: CURSOR cur_inst(cp_person_id igs_fi_parties_v.person_id%TYPE,

733: AND cra.credit_id = crd.credit_id;
734:
735: -- Cursor for validating if any program attempt of the person is in INTERMIT state and the
736: -- intermission type has the study at another institution flag set
737: CURSOR cur_inst(cp_person_id igs_fi_parties_v.person_id%TYPE,
738: cp_crs_stat igs_en_stdnt_ps_att.course_attempt_status%TYPE) IS
739: SELECT 'x'
740: FROM igs_en_stdnt_ps_att spa,
741: igs_en_intm_types intm,

Line 754: CURSOR cur_crs(cp_person_id igs_fi_parties_v.person_id%TYPE) IS

750:
751: -- Cursor for validating if there is any program attempt of the person in
752: -- status INACTIVE or ENROLLED. This validation is required to validate if the Person
753: -- is active in the system
754: CURSOR cur_crs(cp_person_id igs_fi_parties_v.person_id%TYPE) IS
755: SELECT 'x'
756: FROM igs_en_stdnt_ps_att
757: WHERE person_id = cp_person_id
758: AND course_attempt_status IN ('INACTIVE','ENROLLED');

Line 790: l_payee_id igs_fi_parties_v.person_id%TYPE;

786: l_cr_acc_cd igs_fi_refunds.cr_account_cd%TYPE;
787: l_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;
788: l_unapp_amount igs_fi_credits.unapplied_amount%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;

Line 798: l_party_number igs_fi_parties_v.person_number%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;
798: l_party_number igs_fi_parties_v.person_number%TYPE;
799: l_invoice_number igs_fi_inv_int.invoice_number%TYPE;
800: l_group_cd igs_pe_all_persid_group_v.group_cd%TYPE;
801: l_v_message_name fnd_new_messages.message_name%TYPE;
802: l_v_closing_status gl_period_statuses.closing_status%TYPE;