APPS.AR_UPGRADE_CASH_ACCRUAL dependencies on PSA_TRX_TYPES_ALL

Line 688: FROM psa_trx_types_all psa

684: AND app.upgrade_method IS NULL
685: AND ars.org_id = app.org_id
686: AND ars.accounting_method = 'CASH'
687: AND NOT EXISTS ( SELECT '1'
688: FROM psa_trx_types_all psa
689: WHERE inv.cust_trx_type_id = psa.psa_trx_type_id)
690: UNION
691: -- From CM in the case of CM APP
692: SELECT DISTINCT inv.customer_trx_id,

Line 707: FROM psa_trx_types_all psa

703: AND app.upgrade_method IS NULL
704: AND ars.org_id = app.org_id
705: AND ars.accounting_method = 'CASH'
706: AND NOT EXISTS ( SELECT '1'
707: FROM psa_trx_types_all psa
708: WHERE inv.cust_trx_type_id = psa.psa_trx_type_id)) trx,
709: ra_customer_trx_lines_all ctl,
710: ra_cust_trx_line_gl_dist_all ctlgd
711: WHERE trx.customer_trx_id = ctl.customer_trx_id

Line 921: psa_trx_types_all psa

917: inv.set_of_books_id
918: FROM xla_events_gt evt,
919: ar_receivable_applications_all app,
920: ra_customer_trx_all inv,
921: psa_trx_types_all psa
922: WHERE evt.event_type_code
923: IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
924: 'RECP_RATE_ADJUST' ,'RECP_REVERSE' ,
925: 'CM_CREATE' ,'CM_UPDATE' )

Line 938: psa_trx_types_all psa

934: inv.set_of_books_id
935: FROM xla_events_gt evt,
936: ar_receivable_applications_all app,
937: ra_customer_trx_all inv,
938: psa_trx_types_all psa
939: WHERE evt.event_type_code
940: IN ( 'CM_CREATE' ,'CM_UPDATE' )
941: AND evt.event_id = app.event_id
942: AND app.customer_trx_id = inv.customer_trx_id

Line 2507: FROM psa_trx_types_all psa,

2503: AND app.upgrade_method IS NULL
2504: AND app.org_id = ars.org_id
2505: AND ars.accounting_method = 'CASH'
2506: AND NOT EXISTS (SELECT '1'
2507: FROM psa_trx_types_all psa,
2508: ra_customer_trx_all inv
2509: WHERE inv.customer_trx_id = app.applied_customer_trx_id
2510: AND inv.cust_trx_type_id = psa.psa_trx_type_id);
2511: /*

Line 2528: FROM psa_trx_types_all psa,

2524: AND app.upgrade_method IS NULL
2525: AND app.org_id = ars.org_id
2526: AND ars.accounting_method = 'CASH'
2527: AND NOT EXISTS (SELECT '1'
2528: FROM psa_trx_types_all psa,
2529: ra_customer_trx_all inv
2530: WHERE inv.customer_trx_id = app.customer_trx_id
2531: AND inv.cust_trx_type_id = psa.psa_trx_type_id);
2532: */