[Home] [Help]
209: where cash_receipt_id = p_cr_id
210: and nvl(confirmed_flag,'Y') = 'Y'
211: and nvl(postable,'Y') = 'Y'
212: and posting_control_id = -3) src,
213: ar_distributions ard
214: where ard.source_id = src.src_id
215: and ard.source_table = src.src_tab
216: group by src.gl_date;
217:
338: from ar_adjustments
339: where adjustment_id = p_adj_id
340: and nvl(postable,'Y') = 'Y'
341: and posting_control_id = -3) src,
342: ar_distributions ard
343: where ard.source_id = src.src_id
344: and ard.source_table = src.src_tab;
345:
346: --------------------------------------------------------
468: from ar_receivable_applications
469: where receivable_application_id = p_receivable_application_id
470: and nvl(postable,'Y') = 'Y'
471: and posting_control_id = -3) src,
472: ar_distributions ard
473: where ard.source_id = src.src_id
474: and ard.source_table = src.src_tab;
475:
476: --------------------------------------------------------
577: where ( receivable_application_id = p_receivable_application_id1
578: or receivable_application_id = p_receivable_application_id2)
579: and nvl(postable,'Y') = 'Y'
580: and posting_control_id = -3) src,
581: ar_distributions ard
582: where ard.source_id = src.src_id
583: and ard.source_table = src.src_tab;
584:
585: --------------------------------------------------------