APPS.IGS_FI_BILL_EXTRACT dependencies on IGS_FI_PP_STD_ATTRS

Line 1587: cursor c_act_pp_dtls (cp_n_person_id IN igs_fi_pp_std_attrs.person_id%TYPE) IS

1583: records of plan_end_date less than or equal to cutoff date.
1584: ***************************************************************/
1585:
1586: -- cursor to select the payment plan contract signed by student and payment plan status is ACTIVE.
1587: cursor c_act_pp_dtls (cp_n_person_id IN igs_fi_pp_std_attrs.person_id%TYPE) IS
1588: SELECT *
1589: FROM igs_fi_pp_std_attrs
1590: WHERE person_id = cp_n_person_id
1591: AND plan_status_code = 'ACTIVE';

Line 1589: FROM igs_fi_pp_std_attrs

1585:
1586: -- cursor to select the payment plan contract signed by student and payment plan status is ACTIVE.
1587: cursor c_act_pp_dtls (cp_n_person_id IN igs_fi_pp_std_attrs.person_id%TYPE) IS
1588: SELECT *
1589: FROM igs_fi_pp_std_attrs
1590: WHERE person_id = cp_n_person_id
1591: AND plan_status_code = 'ACTIVE';
1592:
1593: --cursor to select the payment plan contract signed by student and payment plan status is CLOSED and DISQUALIFIED.

Line 1594: cursor c_clo_dis_pp_dtls (cp_n_person_id IN igs_fi_pp_std_attrs.person_id%TYPE,

1590: WHERE person_id = cp_n_person_id
1591: AND plan_status_code = 'ACTIVE';
1592:
1593: --cursor to select the payment plan contract signed by student and payment plan status is CLOSED and DISQUALIFIED.
1594: cursor c_clo_dis_pp_dtls (cp_n_person_id IN igs_fi_pp_std_attrs.person_id%TYPE,
1595: cp_d_cutoff_date IN igs_fi_pp_std_attrs.plan_end_date%TYPE) IS
1596: SELECT *
1597: FROM igs_fi_pp_std_attrs
1598: WHERE person_id = cp_n_person_id

Line 1595: cp_d_cutoff_date IN igs_fi_pp_std_attrs.plan_end_date%TYPE) IS

1591: AND plan_status_code = 'ACTIVE';
1592:
1593: --cursor to select the payment plan contract signed by student and payment plan status is CLOSED and DISQUALIFIED.
1594: cursor c_clo_dis_pp_dtls (cp_n_person_id IN igs_fi_pp_std_attrs.person_id%TYPE,
1595: cp_d_cutoff_date IN igs_fi_pp_std_attrs.plan_end_date%TYPE) IS
1596: SELECT *
1597: FROM igs_fi_pp_std_attrs
1598: WHERE person_id = cp_n_person_id
1599: AND plan_status_code IN ('CLOSED','DISQUALIFIED')

Line 1597: FROM igs_fi_pp_std_attrs

1593: --cursor to select the payment plan contract signed by student and payment plan status is CLOSED and DISQUALIFIED.
1594: cursor c_clo_dis_pp_dtls (cp_n_person_id IN igs_fi_pp_std_attrs.person_id%TYPE,
1595: cp_d_cutoff_date IN igs_fi_pp_std_attrs.plan_end_date%TYPE) IS
1596: SELECT *
1597: FROM igs_fi_pp_std_attrs
1598: WHERE person_id = cp_n_person_id
1599: AND plan_status_code IN ('CLOSED','DISQUALIFIED')
1600: AND TRUNC(plan_end_date) <= TRUNC(cp_d_cutoff_date);
1601: