APPS.PN_VAR_RENT_CALC_PKG dependencies on PN_VAR_TRX_HEADERS_ALL

Line 130: pn_var_trx_headers_all

126: ,ytd_deductions
127: ,first_yr_rent
128: ,'N' AS update_flag
129: FROM
130: pn_var_trx_headers_all
131: WHERE
132: var_rent_id = p_vr_id AND
133: period_id = p_prd_id
134: ORDER BY

Line 161: pn_var_trx_headers_all

157: ,percent_rent_due_for
158: ,ytd_percent_rent_for
159: ,'N' AS update_flag
160: FROM
161: pn_var_trx_headers_all
162: WHERE
163: var_rent_id = p_vr_id AND
164: period_id = p_prd_id
165: ORDER BY

Line 205: percent_rent_due pn_var_trx_headers_all.percent_rent_due%TYPE

201: TYPE TRX_HEADER_TBL IS TABLE OF trx_hdr_for_c%ROWTYPE INDEX BY BINARY_INTEGER;
202:
203: TYPE TRX_HDR_RENT_REC IS RECORD
204: (
205: percent_rent_due pn_var_trx_headers_all.percent_rent_due%TYPE
206: ,ytd_percent_rent pn_var_trx_headers_all.ytd_percent_rent%TYPE
207: ,calculated_rent pn_var_trx_headers_all.calculated_rent%TYPE
208: ,prorated_rent_due pn_var_trx_headers_all.prorated_rent_due%TYPE
209: );

Line 206: ,ytd_percent_rent pn_var_trx_headers_all.ytd_percent_rent%TYPE

202:
203: TYPE TRX_HDR_RENT_REC IS RECORD
204: (
205: percent_rent_due pn_var_trx_headers_all.percent_rent_due%TYPE
206: ,ytd_percent_rent pn_var_trx_headers_all.ytd_percent_rent%TYPE
207: ,calculated_rent pn_var_trx_headers_all.calculated_rent%TYPE
208: ,prorated_rent_due pn_var_trx_headers_all.prorated_rent_due%TYPE
209: );
210:

Line 207: ,calculated_rent pn_var_trx_headers_all.calculated_rent%TYPE

203: TYPE TRX_HDR_RENT_REC IS RECORD
204: (
205: percent_rent_due pn_var_trx_headers_all.percent_rent_due%TYPE
206: ,ytd_percent_rent pn_var_trx_headers_all.ytd_percent_rent%TYPE
207: ,calculated_rent pn_var_trx_headers_all.calculated_rent%TYPE
208: ,prorated_rent_due pn_var_trx_headers_all.prorated_rent_due%TYPE
209: );
210:
211: TYPE TRX_HDR_RENT_TBL IS TABLE OF TRX_HDR_RENT_REC INDEX BY BINARY_INTEGER;

Line 208: ,prorated_rent_due pn_var_trx_headers_all.prorated_rent_due%TYPE

204: (
205: percent_rent_due pn_var_trx_headers_all.percent_rent_due%TYPE
206: ,ytd_percent_rent pn_var_trx_headers_all.ytd_percent_rent%TYPE
207: ,calculated_rent pn_var_trx_headers_all.calculated_rent%TYPE
208: ,prorated_rent_due pn_var_trx_headers_all.prorated_rent_due%TYPE
209: );
210:
211: TYPE TRX_HDR_RENT_TBL IS TABLE OF TRX_HDR_RENT_REC INDEX BY BINARY_INTEGER;
212: