eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKL_PAYMENTS_INTERFACE

Line 2795: p_payment_freq_code IN okl_payments_interface.payment_frequency_code%TYPE,

2791: PROCEDURE check_payment_frequency_code(
2792: x_return_status OUT NOCOPY VARCHAR2,
2793: x_msg_count OUT NOCOPY NUMBER,
2794: x_msg_data OUT NOCOPY VARCHAR2,
2795: p_payment_freq_code IN okl_payments_interface.payment_frequency_code%TYPE,
2796: x_id1 OUT NOCOPY okx_tuom_v.id1%TYPE,
2797: x_uom_code OUT NOCOPY okx_tuom_v.uom_code%TYPE
2798: ) IS
2799: /*

Line 2800: CURSOR freq_csr (p_payment_freq_code okl_payments_interface.payment_frequency_code%TYPE) IS

2796: x_id1 OUT NOCOPY okx_tuom_v.id1%TYPE,
2797: x_uom_code OUT NOCOPY okx_tuom_v.uom_code%TYPE
2798: ) IS
2799: /*
2800: CURSOR freq_csr (p_payment_freq_code okl_payments_interface.payment_frequency_code%TYPE) IS
2801: SELECT id1,
2802: uom_code
2803: FROM okx_tuom_v
2804: WHERE uom_class = 'OKL-TIME'

Line 2808: CURSOR freq_csr (p_payment_freq_code okl_payments_interface.payment_frequency_code%TYPE) IS

2804: WHERE uom_class = 'OKL-TIME'
2805: AND base_uom_flag = 'N'
2806: AND name = p_payment_freq_code;
2807: */
2808: CURSOR freq_csr (p_payment_freq_code okl_payments_interface.payment_frequency_code%TYPE) IS
2809: SELECT id1,
2810: id1
2811: FROM okl_time_units_v
2812: WHERE name = p_payment_freq_code;

Line 2885: p_contract_number_old IN okl_payments_interface.contract_number_old%TYPE,

2881: PROCEDURE check_payment_record(
2882: x_return_status OUT NOCOPY VARCHAR2,
2883: x_msg_count OUT NOCOPY NUMBER,
2884: x_msg_data OUT NOCOPY VARCHAR2,
2885: p_contract_number_old IN okl_payments_interface.contract_number_old%TYPE,
2886: p_line_number IN okl_payments_interface.line_number%TYPE,
2887: p_asset_number IN okl_payments_interface.asset_number%TYPE,
2888: p_payment_type_code IN VARCHAR2,
2889: p_stream_purpose IN okl_payments_interface.stream_purpose_code%TYPE,

Line 2886: p_line_number IN okl_payments_interface.line_number%TYPE,

2882: x_return_status OUT NOCOPY VARCHAR2,
2883: x_msg_count OUT NOCOPY NUMBER,
2884: x_msg_data OUT NOCOPY VARCHAR2,
2885: p_contract_number_old IN okl_payments_interface.contract_number_old%TYPE,
2886: p_line_number IN okl_payments_interface.line_number%TYPE,
2887: p_asset_number IN okl_payments_interface.asset_number%TYPE,
2888: p_payment_type_code IN VARCHAR2,
2889: p_stream_purpose IN okl_payments_interface.stream_purpose_code%TYPE,
2890: p_payment_schedule_number IN okl_payments_interface.payment_schedule_number%TYPE,

Line 2887: p_asset_number IN okl_payments_interface.asset_number%TYPE,

2883: x_msg_count OUT NOCOPY NUMBER,
2884: x_msg_data OUT NOCOPY VARCHAR2,
2885: p_contract_number_old IN okl_payments_interface.contract_number_old%TYPE,
2886: p_line_number IN okl_payments_interface.line_number%TYPE,
2887: p_asset_number IN okl_payments_interface.asset_number%TYPE,
2888: p_payment_type_code IN VARCHAR2,
2889: p_stream_purpose IN okl_payments_interface.stream_purpose_code%TYPE,
2890: p_payment_schedule_number IN okl_payments_interface.payment_schedule_number%TYPE,
2891: p_payment_frequency_code IN okl_payments_interface.payment_frequency_code%TYPE,

Line 2889: p_stream_purpose IN okl_payments_interface.stream_purpose_code%TYPE,

2885: p_contract_number_old IN okl_payments_interface.contract_number_old%TYPE,
2886: p_line_number IN okl_payments_interface.line_number%TYPE,
2887: p_asset_number IN okl_payments_interface.asset_number%TYPE,
2888: p_payment_type_code IN VARCHAR2,
2889: p_stream_purpose IN okl_payments_interface.stream_purpose_code%TYPE,
2890: p_payment_schedule_number IN okl_payments_interface.payment_schedule_number%TYPE,
2891: p_payment_frequency_code IN okl_payments_interface.payment_frequency_code%TYPE,
2892: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,
2893: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,

Line 2890: p_payment_schedule_number IN okl_payments_interface.payment_schedule_number%TYPE,

2886: p_line_number IN okl_payments_interface.line_number%TYPE,
2887: p_asset_number IN okl_payments_interface.asset_number%TYPE,
2888: p_payment_type_code IN VARCHAR2,
2889: p_stream_purpose IN okl_payments_interface.stream_purpose_code%TYPE,
2890: p_payment_schedule_number IN okl_payments_interface.payment_schedule_number%TYPE,
2891: p_payment_frequency_code IN okl_payments_interface.payment_frequency_code%TYPE,
2892: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,
2893: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,
2894: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,

Line 2891: p_payment_frequency_code IN okl_payments_interface.payment_frequency_code%TYPE,

2887: p_asset_number IN okl_payments_interface.asset_number%TYPE,
2888: p_payment_type_code IN VARCHAR2,
2889: p_stream_purpose IN okl_payments_interface.stream_purpose_code%TYPE,
2890: p_payment_schedule_number IN okl_payments_interface.payment_schedule_number%TYPE,
2891: p_payment_frequency_code IN okl_payments_interface.payment_frequency_code%TYPE,
2892: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,
2893: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,
2894: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,
2895: p_start_date IN okl_payments_interface.start_date%TYPE,

Line 2892: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,

2888: p_payment_type_code IN VARCHAR2,
2889: p_stream_purpose IN okl_payments_interface.stream_purpose_code%TYPE,
2890: p_payment_schedule_number IN okl_payments_interface.payment_schedule_number%TYPE,
2891: p_payment_frequency_code IN okl_payments_interface.payment_frequency_code%TYPE,
2892: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,
2893: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,
2894: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,
2895: p_start_date IN okl_payments_interface.start_date%TYPE,
2896: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,

Line 2893: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,

2889: p_stream_purpose IN okl_payments_interface.stream_purpose_code%TYPE,
2890: p_payment_schedule_number IN okl_payments_interface.payment_schedule_number%TYPE,
2891: p_payment_frequency_code IN okl_payments_interface.payment_frequency_code%TYPE,
2892: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,
2893: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,
2894: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,
2895: p_start_date IN okl_payments_interface.start_date%TYPE,
2896: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,
2897: p_rate IN okl_payments_interface.rate%TYPE,

Line 2894: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,

2890: p_payment_schedule_number IN okl_payments_interface.payment_schedule_number%TYPE,
2891: p_payment_frequency_code IN okl_payments_interface.payment_frequency_code%TYPE,
2892: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,
2893: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,
2894: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,
2895: p_start_date IN okl_payments_interface.start_date%TYPE,
2896: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,
2897: p_rate IN okl_payments_interface.rate%TYPE,
2898: p_comments IN okl_payments_interface.comments%TYPE,

Line 2895: p_start_date IN okl_payments_interface.start_date%TYPE,

2891: p_payment_frequency_code IN okl_payments_interface.payment_frequency_code%TYPE,
2892: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,
2893: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,
2894: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,
2895: p_start_date IN okl_payments_interface.start_date%TYPE,
2896: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,
2897: p_rate IN okl_payments_interface.rate%TYPE,
2898: p_comments IN okl_payments_interface.comments%TYPE,
2899: p_stub_days IN okl_payments_interface.stub_days%TYPE,

Line 2896: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,

2892: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,
2893: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,
2894: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,
2895: p_start_date IN okl_payments_interface.start_date%TYPE,
2896: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,
2897: p_rate IN okl_payments_interface.rate%TYPE,
2898: p_comments IN okl_payments_interface.comments%TYPE,
2899: p_stub_days IN okl_payments_interface.stub_days%TYPE,
2900: p_stub_amount IN okl_payments_interface.stub_amount%TYPE

Line 2897: p_rate IN okl_payments_interface.rate%TYPE,

2893: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,
2894: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,
2895: p_start_date IN okl_payments_interface.start_date%TYPE,
2896: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,
2897: p_rate IN okl_payments_interface.rate%TYPE,
2898: p_comments IN okl_payments_interface.comments%TYPE,
2899: p_stub_days IN okl_payments_interface.stub_days%TYPE,
2900: p_stub_amount IN okl_payments_interface.stub_amount%TYPE
2901: ) IS

Line 2898: p_comments IN okl_payments_interface.comments%TYPE,

2894: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,
2895: p_start_date IN okl_payments_interface.start_date%TYPE,
2896: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,
2897: p_rate IN okl_payments_interface.rate%TYPE,
2898: p_comments IN okl_payments_interface.comments%TYPE,
2899: p_stub_days IN okl_payments_interface.stub_days%TYPE,
2900: p_stub_amount IN okl_payments_interface.stub_amount%TYPE
2901: ) IS
2902:

Line 2899: p_stub_days IN okl_payments_interface.stub_days%TYPE,

2895: p_start_date IN okl_payments_interface.start_date%TYPE,
2896: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,
2897: p_rate IN okl_payments_interface.rate%TYPE,
2898: p_comments IN okl_payments_interface.comments%TYPE,
2899: p_stub_days IN okl_payments_interface.stub_days%TYPE,
2900: p_stub_amount IN okl_payments_interface.stub_amount%TYPE
2901: ) IS
2902:
2903: x_id1 okx_tuom_v.id1%TYPE;

Line 2900: p_stub_amount IN okl_payments_interface.stub_amount%TYPE

2896: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,
2897: p_rate IN okl_payments_interface.rate%TYPE,
2898: p_comments IN okl_payments_interface.comments%TYPE,
2899: p_stub_days IN okl_payments_interface.stub_days%TYPE,
2900: p_stub_amount IN okl_payments_interface.stub_amount%TYPE
2901: ) IS
2902:
2903: x_id1 okx_tuom_v.id1%TYPE;
2904: x_id2 okl_strmtyp_source_v.id1%TYPE;

Line 3290: FROM okl_payments_interface

3286: --
3287:
3288: CURSOR okl_payment_csr (p_contract_number okc_k_headers_v.contract_number%TYPE) IS
3289: SELECT *
3290: FROM okl_payments_interface
3291: WHERE contract_number_old = p_contract_number;
3292:
3293:
3294: BEGIN -- Actual Procedure Starts Here

Line 22420: p_stream_purpose IN okl_payments_interface.stream_purpose_code%TYPE,

22416: x_msg_data OUT NOCOPY VARCHAR2,
22417: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
22418: p_line_number IN okl_lines_interface.line_number%TYPE,
22419: p_payment_type_code IN VARCHAR2,
22420: p_stream_purpose IN okl_payments_interface.stream_purpose_code%TYPE,
22421: p_chr_id IN NUMBER,
22422: p_cle_id IN NUMBER,
22423: p_rg_id IN NUMBER,
22424: x_rgp_id OUT NOCOPY NUMBER,

Line 22620: p_payment_sch_number IN okl_payments_interface.payment_schedule_number%TYPE,

22616: x_msg_count OUT NOCOPY NUMBER,
22617: x_msg_data OUT NOCOPY VARCHAR2,
22618: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
22619: p_line_number IN okl_lines_interface.line_number%TYPE,
22620: p_payment_sch_number IN okl_payments_interface.payment_schedule_number%TYPE,
22621: p_payment_freq_code IN okl_payments_interface.payment_frequency_code%TYPE,
22622: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,
22623: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,
22624: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,

Line 22621: p_payment_freq_code IN okl_payments_interface.payment_frequency_code%TYPE,

22617: x_msg_data OUT NOCOPY VARCHAR2,
22618: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
22619: p_line_number IN okl_lines_interface.line_number%TYPE,
22620: p_payment_sch_number IN okl_payments_interface.payment_schedule_number%TYPE,
22621: p_payment_freq_code IN okl_payments_interface.payment_frequency_code%TYPE,
22622: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,
22623: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,
22624: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,
22625: p_start_date IN okl_payments_interface.start_date%TYPE,

Line 22622: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,

22618: p_contract_number IN okl_header_interface.contract_number_old%TYPE,
22619: p_line_number IN okl_lines_interface.line_number%TYPE,
22620: p_payment_sch_number IN okl_payments_interface.payment_schedule_number%TYPE,
22621: p_payment_freq_code IN okl_payments_interface.payment_frequency_code%TYPE,
22622: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,
22623: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,
22624: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,
22625: p_start_date IN okl_payments_interface.start_date%TYPE,
22626: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,

Line 22623: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,

22619: p_line_number IN okl_lines_interface.line_number%TYPE,
22620: p_payment_sch_number IN okl_payments_interface.payment_schedule_number%TYPE,
22621: p_payment_freq_code IN okl_payments_interface.payment_frequency_code%TYPE,
22622: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,
22623: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,
22624: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,
22625: p_start_date IN okl_payments_interface.start_date%TYPE,
22626: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,
22627: p_rate IN okl_payments_interface.rate%TYPE,

Line 22624: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,

22620: p_payment_sch_number IN okl_payments_interface.payment_schedule_number%TYPE,
22621: p_payment_freq_code IN okl_payments_interface.payment_frequency_code%TYPE,
22622: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,
22623: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,
22624: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,
22625: p_start_date IN okl_payments_interface.start_date%TYPE,
22626: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,
22627: p_rate IN okl_payments_interface.rate%TYPE,
22628: p_comments IN okl_payments_interface.comments%TYPE,

Line 22625: p_start_date IN okl_payments_interface.start_date%TYPE,

22621: p_payment_freq_code IN okl_payments_interface.payment_frequency_code%TYPE,
22622: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,
22623: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,
22624: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,
22625: p_start_date IN okl_payments_interface.start_date%TYPE,
22626: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,
22627: p_rate IN okl_payments_interface.rate%TYPE,
22628: p_comments IN okl_payments_interface.comments%TYPE,
22629: p_stub_days IN okl_payments_interface.stub_days%TYPE,

Line 22626: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,

22622: p_arrears_flag IN okl_payments_interface.arrears_flag%TYPE,
22623: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,
22624: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,
22625: p_start_date IN okl_payments_interface.start_date%TYPE,
22626: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,
22627: p_rate IN okl_payments_interface.rate%TYPE,
22628: p_comments IN okl_payments_interface.comments%TYPE,
22629: p_stub_days IN okl_payments_interface.stub_days%TYPE,
22630: p_stub_amount IN okl_payments_interface.stub_amount%TYPE,

Line 22627: p_rate IN okl_payments_interface.rate%TYPE,

22623: p_advance_payments IN okl_payments_interface.advance_payments%TYPE,
22624: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,
22625: p_start_date IN okl_payments_interface.start_date%TYPE,
22626: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,
22627: p_rate IN okl_payments_interface.rate%TYPE,
22628: p_comments IN okl_payments_interface.comments%TYPE,
22629: p_stub_days IN okl_payments_interface.stub_days%TYPE,
22630: p_stub_amount IN okl_payments_interface.stub_amount%TYPE,
22631: p_slh_rulv_rec IN rulv_rec_type,

Line 22628: p_comments IN okl_payments_interface.comments%TYPE,

22624: p_payment_amount IN okl_payments_interface.payment_amount%TYPE,
22625: p_start_date IN okl_payments_interface.start_date%TYPE,
22626: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,
22627: p_rate IN okl_payments_interface.rate%TYPE,
22628: p_comments IN okl_payments_interface.comments%TYPE,
22629: p_stub_days IN okl_payments_interface.stub_days%TYPE,
22630: p_stub_amount IN okl_payments_interface.stub_amount%TYPE,
22631: p_slh_rulv_rec IN rulv_rec_type,
22632: p_chr_id IN NUMBER,

Line 22629: p_stub_days IN okl_payments_interface.stub_days%TYPE,

22625: p_start_date IN okl_payments_interface.start_date%TYPE,
22626: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,
22627: p_rate IN okl_payments_interface.rate%TYPE,
22628: p_comments IN okl_payments_interface.comments%TYPE,
22629: p_stub_days IN okl_payments_interface.stub_days%TYPE,
22630: p_stub_amount IN okl_payments_interface.stub_amount%TYPE,
22631: p_slh_rulv_rec IN rulv_rec_type,
22632: p_chr_id IN NUMBER,
22633: p_cle_id IN NUMBER,

Line 22630: p_stub_amount IN okl_payments_interface.stub_amount%TYPE,

22626: p_number_of_periods IN okl_payments_interface.number_of_periods%TYPE,
22627: p_rate IN okl_payments_interface.rate%TYPE,
22628: p_comments IN okl_payments_interface.comments%TYPE,
22629: p_stub_days IN okl_payments_interface.stub_days%TYPE,
22630: p_stub_amount IN okl_payments_interface.stub_amount%TYPE,
22631: p_slh_rulv_rec IN rulv_rec_type,
22632: p_chr_id IN NUMBER,
22633: p_cle_id IN NUMBER,
22634: p_rgp_id IN NUMBER

Line 27553: l_asset_number_prev okl_payments_interface.asset_number%TYPE;

27549: x_comb_id NUMBER;
27550: x_rgp_id NUMBER;
27551: l_contract_number_old_prev okl_header_interface.contract_number_old%TYPE;
27552: l_line_number_prev okl_lines_interface.line_number%TYPE;
27553: l_asset_number_prev okl_payments_interface.asset_number%TYPE;
27554: l_payment_type_code_prev okl_payments_interface.payment_type_code%TYPE;
27555: l_pmnt_sch_num_prev NUMBER;
27556: l_start_date_prev DATE;
27557: l_number_of_periods_prev NUMBER;

Line 27554: l_payment_type_code_prev okl_payments_interface.payment_type_code%TYPE;

27550: x_rgp_id NUMBER;
27551: l_contract_number_old_prev okl_header_interface.contract_number_old%TYPE;
27552: l_line_number_prev okl_lines_interface.line_number%TYPE;
27553: l_asset_number_prev okl_payments_interface.asset_number%TYPE;
27554: l_payment_type_code_prev okl_payments_interface.payment_type_code%TYPE;
27555: l_pmnt_sch_num_prev NUMBER;
27556: l_start_date_prev DATE;
27557: l_number_of_periods_prev NUMBER;
27558: x_pmnt_freq_id okx_tuom_v.id1%TYPE;

Line 28549: FROM okl_payments_interface

28545: --
28546: CURSOR okl_payment_csr (p_contract_number_old VARCHAR2,
28547: p_line_number NUMBER) IS
28548: SELECT *
28549: FROM okl_payments_interface
28550: WHERE contract_number_old = p_contract_number_old
28551: AND payment_type_code <> 'RENT' -- Bug 5155206
28552: AND ( (line_number = p_line_number
28553: AND

Line 28651: FROM okl_payments_interface

28647: type RENT only */
28648: CURSOR okl_payment_rent_csr (p_contract_number_old VARCHAR2,
28649: p_line_number NUMBER) IS
28650: SELECT *
28651: FROM okl_payments_interface
28652: WHERE contract_number_old = p_contract_number_old
28653: AND payment_type_code = 'RENT'
28654: AND ( (line_number = p_line_number
28655: AND

Line 30713: --to utilize these variables for processing non rent records in okl_payments_interface

30709:
30710: -- Save current values for future comparison
30711: --abhsaxen 13-feb-2008 bug#6773219
30712: --commented this portion and added the same just at the end of line processing loop
30713: --to utilize these variables for processing non rent records in okl_payments_interface
30714: --like ESTIMATED PERSONAL PROPERTY TAX
30715: --l_prev_asset_number := okl_line_rec.asset_number;
30716: --l_prev_corp_book := okl_line_rec.asset_corporate_book;
30717: --l_prev_tax_book := okl_line_rec.tax_book;