APPS.AR_UPGRADE_CASH_ACCRUAL dependencies on PSA_TRX_TYPES_ALL

Line 714: FROM psa_trx_types_all psa

710: AND app.upgrade_method IS NULL
711: AND ars.org_id = app.org_id
712: AND ars.accounting_method = 'CASH'
713: AND NOT EXISTS ( SELECT '1'
714: FROM psa_trx_types_all psa
715: WHERE inv.cust_trx_type_id = psa.psa_trx_type_id)
716: UNION
717: -- From CM in the case of CM APP
718: SELECT DISTINCT inv.customer_trx_id,

Line 733: FROM psa_trx_types_all psa

729: AND app.upgrade_method IS NULL
730: AND ars.org_id = app.org_id
731: AND ars.accounting_method = 'CASH'
732: AND NOT EXISTS ( SELECT '1'
733: FROM psa_trx_types_all psa
734: WHERE inv.cust_trx_type_id = psa.psa_trx_type_id)) trx,
735: ra_customer_trx_lines_all ctl,
736: ra_cust_trx_line_gl_dist_all ctlgd
737: WHERE trx.customer_trx_id = ctl.customer_trx_id

Line 947: psa_trx_types_all psa

943: inv.set_of_books_id
944: FROM xla_events_gt evt,
945: ar_receivable_applications_all app,
946: ra_customer_trx_all inv,
947: psa_trx_types_all psa
948: WHERE evt.event_type_code
949: IN ( 'RECP_CREATE' ,'RECP_UPDATE' ,
950: 'RECP_RATE_ADJUST' ,'RECP_REVERSE' ,
951: 'CM_CREATE' ,'CM_UPDATE' )

Line 964: psa_trx_types_all psa

960: inv.set_of_books_id
961: FROM xla_events_gt evt,
962: ar_receivable_applications_all app,
963: ra_customer_trx_all inv,
964: psa_trx_types_all psa
965: WHERE evt.event_type_code
966: IN ( 'CM_CREATE' ,'CM_UPDATE' )
967: AND evt.event_id = app.event_id
968: AND app.customer_trx_id = inv.customer_trx_id

Line 2726: FROM psa_trx_types_all psa,

2722: AND app.upgrade_method IS NULL
2723: AND app.org_id = ars.org_id
2724: AND ars.accounting_method = 'CASH'
2725: AND NOT EXISTS (SELECT '1'
2726: FROM psa_trx_types_all psa,
2727: ra_customer_trx_all inv
2728: WHERE inv.customer_trx_id = app.applied_customer_trx_id
2729: AND inv.cust_trx_type_id = psa.psa_trx_type_id);
2730: /*

Line 2747: FROM psa_trx_types_all psa,

2743: AND app.upgrade_method IS NULL
2744: AND app.org_id = ars.org_id
2745: AND ars.accounting_method = 'CASH'
2746: AND NOT EXISTS (SELECT '1'
2747: FROM psa_trx_types_all psa,
2748: ra_customer_trx_all inv
2749: WHERE inv.customer_trx_id = app.customer_trx_id
2750: AND inv.cust_trx_type_id = psa.psa_trx_type_id);
2751: */