APPS.IGS_FI_PRC_FIN_LT_CHG dependencies on IGS_FI_PARTIES_V

Line 47: --sarakshi 27-Feb-2002 bug:2238362, changed the view igs_pe_person_v to igs_fi_parties_v and used the

43: -- Billing Cutoff date comparision with the Charge Creation Date is Corrected
44: --SYKRISHN -5-APR-02 Enh Bug : 2293676 - Introduction of functionality of planned credits -
45: -- According to SFCR018 Build - Introduced the function get_planned_credits_ind
46: -- and associated code.
47: --sarakshi 27-Feb-2002 bug:2238362, changed the view igs_pe_person_v to igs_fi_parties_v and used the
48: -- function igs_fi_gen_007.validate_person to validate person, removed validate
49: -- person_id local function.
50: -------------------------------------------------------------------
51:

Line 243: --bug:2238362, changed the view igs_pe_person_v to igs_fi_parties_v

239:
240: ********************************************************************************************** */
241: CURSOR cur_person IS
242: SELECT person_number,full_name
243: --bug:2238362, changed the view igs_pe_person_v to igs_fi_parties_v
244: FROM igs_fi_parties_v
245: WHERE person_id= p_person_id;
246: l_cur_person cur_person%ROWTYPE;
247:

Line 244: FROM igs_fi_parties_v

240: ********************************************************************************************** */
241: CURSOR cur_person IS
242: SELECT person_number,full_name
243: --bug:2238362, changed the view igs_pe_person_v to igs_fi_parties_v
244: FROM igs_fi_parties_v
245: WHERE person_id= p_person_id;
246: l_cur_person cur_person%ROWTYPE;
247:
248: BEGIN

Line 760: CURSOR cur_bill(cp_n_person_id igs_fi_parties_v.person_id%TYPE) IS

756: Change History
757: Who When What
758: ************************************************************************************************/
759:
760: CURSOR cur_bill(cp_n_person_id igs_fi_parties_v.person_id%TYPE) IS
761: SELECT cut_off_date
762: FROM igs_fi_bill
763: WHERE person_id = cp_n_person_id
764: ORDER BY bill_date DESC;

Line 1488: l_v_person_number igs_fi_parties_v.person_number%TYPE := NULL;

1484:
1485: --Ref cursor variable.
1486: l_cur_ref cur_ref;
1487:
1488: l_v_person_number igs_fi_parties_v.person_number%TYPE := NULL;
1489:
1490: CURSOR cur_fee(cp_fee_type igs_fi_f_typ_ca_inst_all.fee_type%TYPE,
1491: cp_fee_cal_type igs_fi_f_typ_ca_inst_all.fee_cal_type%TYPE,
1492: cp_fee_ci_sequence_number igs_fi_f_typ_ca_inst_all.fee_ci_sequence_number%TYPE) IS

Line 1527: l_n_person_id igs_fi_parties_v.person_id%TYPE;

1523: l_d_gl_date igs_fi_credits_all.gl_date%TYPE;
1524: l_v_message_name fnd_new_messages.message_name%TYPE;
1525: l_v_manage_accounts igs_fi_control.manage_accounts%TYPE;
1526:
1527: l_n_person_id igs_fi_parties_v.person_id%TYPE;
1528: l_v_sql VARCHAR2(32767);
1529: l_v_status VARCHAR2(1);
1530: l_n_act_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE;
1531: l_v_act_plan_name igs_fi_pp_std_attrs.payment_plan_name%TYPE;