965: p_int_receivables_trx_id number;
966: BEGIN
967: select rt.receivables_trx_id
968: into p_int_receivables_trx_id
969: from ar_receivables_trx rt
970: where rt.receivables_trx_id =
971: ( select decode(rsu_st.finchrg_receivables_trx_id,
972: '',decode(rsu_bt.finchrg_receivables_trx_id,
973: '',sp.finchrg_receivables_trx_id,
1007: BEGIN
1008:
1009: select rt.receivables_trx_id
1010: into l_penalty_receivables_trx_id
1011: from ar_receivables_trx rt
1012: where rt.receivables_trx_id = (select sp.penalty_rec_trx_id
1013: from ar_system_parameters sp
1014: where sp.org_id = p_org_id)
1015: and rt.type = 'FINCHRG'