APPS.PN_VARIABLE_TERM_PKG dependencies on PN_PAYMENT_SCHEDULES_ALL

Line 694: l_payment_status_lookup_code pn_payment_schedules_all.payment_status_lookup_code%type;

690: l_area pn_payment_terms.area%TYPE;
691: l_area_type_code pn_payment_terms.area_type_code%TYPE;
692: l_org_id NUMBER;
693: l_schedule_day_char VARCHAR2(8);
694: l_payment_status_lookup_code pn_payment_schedules_all.payment_status_lookup_code%type;
695: i_cnt number;
696:
697: CURSOR csr_distributions (p_var_rent_id IN NUMBER)
698: IS

Line 1107: FROM pn_payment_schedules_all

1103: x_payment_status_lookup_code OUT NOCOPY VARCHAR2) IS
1104:
1105: CURSOR get_schedule_cur IS
1106: SELECT payment_status_lookup_code
1107: FROM pn_payment_schedules_all
1108: WHERE lease_id = p_lease_id
1109: AND schedule_date = p_schedule_date;
1110:
1111: BEGIN