APPS.AR_UPG_PSA_DIST_PKG dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 513: FROM ar_receivable_applications_all app,

509: ABS(NVL(ard.ACCTD_AMOUNT_CR,0)-NVL(ard.ACCTD_AMOUNT_DR,0)),NULL)) --FROM_ACCTD_AMOUNT_CR
510: --
511: , DECODE(double.side,'CASH','N','Y') -- REF_MF_DIST_FLAG
512: , ard.REF_DIST_CCID
513: FROM ar_receivable_applications_all app,
514: ar_distributions_all ard,
515: (SELECT 'CASH' side FROM DUAL UNION
516: SELECT 'APP' side FROM DUAL ) double,
517: ar_cash_receipt_history_all crh

Line 942: ar_receivable_applications_all app,

938: 'EDISC' ,'Y',
939: 'UNEDISC','Y'))) -- REF_MF_DIST_FLAG
940: , NULL -- REF_DIST_CCID
941: FROM
942: ar_receivable_applications_all app,
943: psa_mf_rct_dist_all a,
944: psa_mf_trx_dist_all psatd,
945: ra_cust_trx_line_gl_dist_all ctlgd,
946: (SELECT 'REC' source_type FROM DUAL UNION

Line 966: UPDATE ar_receivable_applications_all app

962: 'UNEDISC',a.UE_DISCOUNT_AMOUNT),0) <> 0;
963:
964:
965:
966: UPDATE ar_receivable_applications_all app
967: SET upgrade_method = '11I_MFAR_UPG'
968: WHERE app.rowid >= l_start_rowid
969: AND app.rowid <= l_end_rowid
970: AND EXISTS (SELECT NULL FROM psa_mf_rct_dist_all psa