APPS.PNP_UTIL_FUNC dependencies on PN_PAYMENT_TERMS_ALL

Line 75: TYPE item_end_dt_rec IS RECORD (term_id pn_payment_terms_all.payment_term_id%TYPE,

71: schedule_date DATE);
72:
73: TYPE virtual_sched_tbl_type IS TABLE OF virtual_sched_rec INDEX BY BINARY_INTEGER;
74:
75: TYPE item_end_dt_rec IS RECORD (term_id pn_payment_terms_all.payment_term_id%TYPE,
76: item_end_dt DATE,
77: index_period_id pn_payment_terms_all.index_period_id%TYPE);
78:
79: TYPE item_end_dt_tbl_type IS TABLE OF item_end_dt_rec INDEX BY BINARY_INTEGER;

Line 77: index_period_id pn_payment_terms_all.index_period_id%TYPE);

73: TYPE virtual_sched_tbl_type IS TABLE OF virtual_sched_rec INDEX BY BINARY_INTEGER;
74:
75: TYPE item_end_dt_rec IS RECORD (term_id pn_payment_terms_all.payment_term_id%TYPE,
76: item_end_dt DATE,
77: index_period_id pn_payment_terms_all.index_period_id%TYPE);
78:
79: TYPE item_end_dt_tbl_type IS TABLE OF item_end_dt_rec INDEX BY BINARY_INTEGER;
80:
81: -------------------------------------------------------------------------------

Line 1020: -- pn_payment_terms.%TYPE to pn_payment_terms_all.%TYPE

1016: -- the tenancy percentage share.
1017: -- HISTORY
1018: -- 21-APR-05 ftanudja o created. #4324777
1019: -- 01-SEP-05 Kiran o Changed the type of params from
1020: -- pn_payment_terms.%TYPE to pn_payment_terms_all.%TYPE
1021: -------------------------------------------------------------------------------
1022: FUNCTION fetch_tenancy_area (
1023: p_lease_id pn_payment_terms_all.lease_id%TYPE,
1024: p_location_id pn_payment_terms_all.location_id%TYPE,

Line 1023: p_lease_id pn_payment_terms_all.lease_id%TYPE,

1019: -- 01-SEP-05 Kiran o Changed the type of params from
1020: -- pn_payment_terms.%TYPE to pn_payment_terms_all.%TYPE
1021: -------------------------------------------------------------------------------
1022: FUNCTION fetch_tenancy_area (
1023: p_lease_id pn_payment_terms_all.lease_id%TYPE,
1024: p_location_id pn_payment_terms_all.location_id%TYPE,
1025: p_as_of_date pn_payment_terms_all.start_date%TYPE,
1026: p_area_type_code pn_payment_terms_all.area_type_code%TYPE)
1027: RETURN NUMBER;

Line 1024: p_location_id pn_payment_terms_all.location_id%TYPE,

1020: -- pn_payment_terms.%TYPE to pn_payment_terms_all.%TYPE
1021: -------------------------------------------------------------------------------
1022: FUNCTION fetch_tenancy_area (
1023: p_lease_id pn_payment_terms_all.lease_id%TYPE,
1024: p_location_id pn_payment_terms_all.location_id%TYPE,
1025: p_as_of_date pn_payment_terms_all.start_date%TYPE,
1026: p_area_type_code pn_payment_terms_all.area_type_code%TYPE)
1027: RETURN NUMBER;
1028:

Line 1025: p_as_of_date pn_payment_terms_all.start_date%TYPE,

1021: -------------------------------------------------------------------------------
1022: FUNCTION fetch_tenancy_area (
1023: p_lease_id pn_payment_terms_all.lease_id%TYPE,
1024: p_location_id pn_payment_terms_all.location_id%TYPE,
1025: p_as_of_date pn_payment_terms_all.start_date%TYPE,
1026: p_area_type_code pn_payment_terms_all.area_type_code%TYPE)
1027: RETURN NUMBER;
1028:
1029: --------------------------------------------------------------------------------

Line 1026: p_area_type_code pn_payment_terms_all.area_type_code%TYPE)

1022: FUNCTION fetch_tenancy_area (
1023: p_lease_id pn_payment_terms_all.lease_id%TYPE,
1024: p_location_id pn_payment_terms_all.location_id%TYPE,
1025: p_as_of_date pn_payment_terms_all.start_date%TYPE,
1026: p_area_type_code pn_payment_terms_all.area_type_code%TYPE)
1027: RETURN NUMBER;
1028:
1029: --------------------------------------------------------------------------------
1030: -- FUNCTION : create_virtual_schedules