APPS.AR_UPG_PSA_DIST_PKG dependencies on PSA_MF_RCT_DIST_ALL

Line 473: , 'PSA_MF_RCT_DIST_ALL' -- SOURCE_TYPE_SECONDARY

469: , ard.THIRD_PARTY_SUB_ID
470: , ard.REVERSED_SOURCE_ID
471: , ard.TAX_CODE_ID
472: , ard.LOCATION_SEGMENT_ID
473: , 'PSA_MF_RCT_DIST_ALL' -- SOURCE_TYPE_SECONDARY
474: , ard.TAX_GROUP_CODE_ID
475: , ard.REF_CUSTOMER_TRX_LINE_ID
476: , ard.REF_CUST_TRX_LINE_GL_DIST_ID
477: , ard.REF_ACCOUNT_CLASS

Line 527: AND EXISTS (SELECT NULL FROM psa_mf_rct_dist_all psa

523: AND DECODE(double.side,'CASH',
524: DECODE(crh.cash_receipt_history_id,
525: NULL,'N','Y'),
526: 'APP' ,'Y') = 'Y'
527: AND EXISTS (SELECT NULL FROM psa_mf_rct_dist_all psa
528: WHERE psa.receivable_application_id = app.receivable_application_id);
529:
530: l_rows_processed := l_rows_processed + SQL%ROWCOUNT;
531:

Line 787: , 'PSA_MF_RCT_DIST_ALL' -- SOURCE_TYPE_SECONDARY

783: , NULL -- THIRD_PARTY_SUB_ID
784: , NULL -- REVERSED_SOURCE_ID
785: , NULL -- TAX_CODE_ID
786: , NULL -- LOCATION_SEGMENT_ID
787: , 'PSA_MF_RCT_DIST_ALL' -- SOURCE_TYPE_SECONDARY
788: , NULL -- TAX_GROUP_CODE_ID
789: , ctlgd.customer_trx_line_id -- REF_CUSTOMER_TRX_LINE_ID
790: , ctlgd.cust_trx_line_gl_dist_id -- REF_CUST_TRX_LINE_GL_DIST_ID
791: , ctlgd.account_class -- REF_ACCOUNT_CLASS

Line 943: psa_mf_rct_dist_all a,

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
947: SELECT 'EDISC' source_type FROM DUAL UNION

Line 970: AND EXISTS (SELECT NULL FROM psa_mf_rct_dist_all psa

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
971: WHERE psa.receivable_application_id = app.receivable_application_id);
972:
973:
974: ad_parallel_updates_pkg.processed_rowid_range(