APPS.IGS_FI_PAYMENT_PLANS dependencies on IGS_FI_PP_TMPL_LNS

Line 549: FROM igs_fi_pp_tmpl_lns

545:
546: --Cursor for fetching all the installment lines for the payment plan passed as input.
547: CURSOR cur_pp_lines(cp_v_pmt_plan igs_fi_pp_templates.payment_plan_name%TYPE) IS
548: SELECT *
549: FROM igs_fi_pp_tmpl_lns
550: WHERE payment_plan_name = cp_v_pmt_plan;
551:
552: --Cursor used to validate if the Person has a Payment Plan with status as Planned.
553: CURSOR cur_pp_planned(cp_n_person_id igs_fi_parties_v.person_id%TYPE) IS

Line 570: plan_line_num igs_fi_pp_tmpl_lns.plan_line_num%TYPE,

566: AND TRUNC(cp_d_start_date) <= TRUNC(plan_end_date);
567:
568: --Declare a local PL/SQL Table to hold certain values for the creation of student payment plan record.
569: TYPE temp_rec_type IS RECORD (
570: plan_line_num igs_fi_pp_tmpl_lns.plan_line_num%TYPE,
571: plan_amount igs_fi_pp_tmpl_lns.plan_amt%TYPE,
572: due_date igs_fi_pp_instlmnts.due_date%TYPE);
573:
574: TYPE temp_tbl_type IS TABLE OF temp_rec_type INDEX BY BINARY_INTEGER;

Line 571: plan_amount igs_fi_pp_tmpl_lns.plan_amt%TYPE,

567:
568: --Declare a local PL/SQL Table to hold certain values for the creation of student payment plan record.
569: TYPE temp_rec_type IS RECORD (
570: plan_line_num igs_fi_pp_tmpl_lns.plan_line_num%TYPE,
571: plan_amount igs_fi_pp_tmpl_lns.plan_amt%TYPE,
572: due_date igs_fi_pp_instlmnts.due_date%TYPE);
573:
574: TYPE temp_tbl_type IS TABLE OF temp_rec_type INDEX BY BINARY_INTEGER;
575: l_temp_plsql_tbl temp_tbl_type;