APPS.PN_VARIABLE_TERM_PKG dependencies on PN_PAYMENT_SCHEDULES_ALL

Line 698: l_payment_status_lookup_code pn_payment_schedules_all.payment_status_lookup_code%type;

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

Line 1111: FROM pn_payment_schedules_all

1107: x_payment_status_lookup_code OUT NOCOPY VARCHAR2) IS
1108:
1109: CURSOR get_schedule_cur IS
1110: SELECT payment_status_lookup_code
1111: FROM pn_payment_schedules_all
1112: WHERE lease_id = p_lease_id
1113: AND schedule_date = p_schedule_date;
1114:
1115: BEGIN