APPS.ARP_BALANCE_CHECK dependencies on AR_RECEIVABLE_APPLICATIONS

Line 212: select /*+ index(RA AR_RECEIVABLE_APPLICATIONS_N1) */

208: where cash_receipt_id = p_cr_id
209: and posting_control_id = -3
210: and nvl(postable_flag,'Y') = 'Y'
211: UNION ALL
212: select /*+ index(RA AR_RECEIVABLE_APPLICATIONS_N1) */
213: cash_receipt_id cr_id,
214: receivable_application_id src_id,
215: 'RA' src_tab,
216: decode(amount_applied_from,NULL,

Line 220: from ar_receivable_applications

216: decode(amount_applied_from,NULL,
217: 'N',
218: 'Y') cc_flag,
219: gl_date
220: from ar_receivable_applications
221: where cash_receipt_id = p_cr_id
222: and nvl(confirmed_flag,'Y') = 'Y'
223: and nvl(postable,'Y') = 'Y'
224: and posting_control_id = -3) src,

Line 456: from ar_cash_receipts cr, ar_receivable_applications ra

452: decode(ra.amount_applied_from,NULL,
453: 'N',
454: 'Y') cc_flag,
455: ra.gl_date
456: from ar_cash_receipts cr, ar_receivable_applications ra
457: where cr.cash_receipt_id between p_cr_id_low and p_cr_id_high
458: and cr.cash_receipt_id = ra.cash_receipt_id
459: and nvl(ra.confirmed_flag,'Y') = 'Y'
460: and nvl(ra.postable,'Y') = 'Y'

Line 780: from ar_receivable_applications

776: sum(nvl(acctd_amount_dr,0)), sum(nvl(acctd_amount_cr,0))
777: into l_amt_dr, l_amt_cr, l_acctd_amt_dr, l_acctd_amt_cr
778: from (select receivable_application_id src_id,
779: 'RA' src_tab
780: from ar_receivable_applications
781: where receivable_application_id = p_receivable_application_id
782: and nvl(postable,'Y') = 'Y'
783: and posting_control_id = -3) src,
784: ar_distributions ard

Line 970: from ar_receivable_applications

966: 'RA' src_tab,
967: decode(amount_applied_from,NULL,
968: 'N',
969: 'Y') cc_flag
970: from ar_receivable_applications
971: where ( receivable_application_id = p_receivable_application_id1
972: or receivable_application_id = p_receivable_application_id2)
973: and nvl(postable,'Y') = 'Y'
974: and posting_control_id = -3) src,

Line 1090: FROM ar_receivable_applications ra

1086: SELECT MAX(apply_date)
1087: INTO l_max_apply_date
1088: FROM (
1089: SELECT MAX(apply_date) apply_date
1090: FROM ar_receivable_applications ra
1091: WHERE status = 'APP'
1092: AND ra.payment_schedule_id = p_ps_rec.payment_schedule_id
1093: UNION ALL
1094: SELECT MAX(apply_date) apply_date

Line 1095: FROM ar_receivable_applications ra

1091: WHERE status = 'APP'
1092: AND ra.payment_schedule_id = p_ps_rec.payment_schedule_id
1093: UNION ALL
1094: SELECT MAX(apply_date) apply_date
1095: FROM ar_receivable_applications ra
1096: WHERE status = 'APP'
1097: AND ra.applied_payment_schedule_id = p_ps_rec.payment_schedule_id
1098: UNION ALL
1099: SELECT MAX(apply_date) apply_date

Line 1107: FROM ar_receivable_applications ra

1103: );
1104: ELSE
1105: SELECT MAX(apply_date)
1106: INTO l_max_apply_date
1107: FROM ar_receivable_applications ra
1108: WHERE payment_schedule_id = p_ps_rec.payment_schedule_id;
1109: END IF;
1110:
1111: IF NVL(l_max_apply_date,p_ps_rec.actual_date_closed) > p_ps_rec.actual_date_closed THEN

Line 1134: FROM ar_receivable_applications ra

1130: SELECT MAX(gl_date)
1131: INTO l_max_gl_date
1132: FROM (
1133: SELECT MAX(gl_date) gl_date
1134: FROM ar_receivable_applications ra
1135: WHERE status = 'APP'
1136: AND ra.payment_schedule_id = p_ps_rec.payment_schedule_id
1137: UNION ALL
1138: SELECT MAX(gl_date) gl_date

Line 1139: FROM ar_receivable_applications ra

1135: WHERE status = 'APP'
1136: AND ra.payment_schedule_id = p_ps_rec.payment_schedule_id
1137: UNION ALL
1138: SELECT MAX(gl_date) gl_date
1139: FROM ar_receivable_applications ra
1140: WHERE status = 'APP'
1141: AND ra.applied_payment_schedule_id = p_ps_rec.payment_schedule_id
1142: UNION ALL
1143: SELECT MAX(gl_date) gl_date

Line 1151: FROM ar_receivable_applications ra

1147: );
1148: ELSE
1149: SELECT MAX(gl_date)
1150: INTO l_max_gl_date
1151: FROM ar_receivable_applications ra
1152: WHERE payment_schedule_id = p_ps_rec.payment_schedule_id;
1153: END IF;
1154:
1155: IF NVL(l_max_gl_date,p_ps_rec.gl_date_closed) > p_ps_rec.gl_date_closed THEN