APPS.ARP_TRX_COMPLETE_CHK dependencies on RA_CUST_TRX_TYPES

Line 469: ra_cust_trx_types ctt

465: ctt.type class,
466: ctt.tax_calculation_flag tax_calculation_flag,
467: ct.customer_trx_id customer_trx_id
468: FROM ra_customer_trx ct,
469: ra_cust_trx_types ctt
470: WHERE ct.cust_trx_type_id = ctt.cust_trx_type_id
471: AND ct.customer_trx_id IN (' || p_query_string || ')';
472:
473: IF PG_DEBUG in ('Y', 'C') THEN

Line 712: l_class ra_cust_trx_types.type%type;

708: l_trx_rec ra_customer_trx%rowtype;
709: l_prev_trx_rec ra_customer_trx%rowtype;
710: l_commit_trx_rec ra_customer_trx%rowtype;
711:
712: l_class ra_cust_trx_types.type%type;
713: l_credited_class ra_cust_trx_types.type%type;
714: l_creation_sign ra_cust_trx_types.creation_sign%type;
715: l_allow_overapplication_flag
716: ra_cust_trx_types.allow_overapplication_flag%type;

Line 713: l_credited_class ra_cust_trx_types.type%type;

709: l_prev_trx_rec ra_customer_trx%rowtype;
710: l_commit_trx_rec ra_customer_trx%rowtype;
711:
712: l_class ra_cust_trx_types.type%type;
713: l_credited_class ra_cust_trx_types.type%type;
714: l_creation_sign ra_cust_trx_types.creation_sign%type;
715: l_allow_overapplication_flag
716: ra_cust_trx_types.allow_overapplication_flag%type;
717: l_natural_app_only_flag

Line 714: l_creation_sign ra_cust_trx_types.creation_sign%type;

710: l_commit_trx_rec ra_customer_trx%rowtype;
711:
712: l_class ra_cust_trx_types.type%type;
713: l_credited_class ra_cust_trx_types.type%type;
714: l_creation_sign ra_cust_trx_types.creation_sign%type;
715: l_allow_overapplication_flag
716: ra_cust_trx_types.allow_overapplication_flag%type;
717: l_natural_app_only_flag
718: ra_cust_trx_types.natural_application_only_flag%type;

Line 716: ra_cust_trx_types.allow_overapplication_flag%type;

712: l_class ra_cust_trx_types.type%type;
713: l_credited_class ra_cust_trx_types.type%type;
714: l_creation_sign ra_cust_trx_types.creation_sign%type;
715: l_allow_overapplication_flag
716: ra_cust_trx_types.allow_overapplication_flag%type;
717: l_natural_app_only_flag
718: ra_cust_trx_types.natural_application_only_flag%type;
719:
720: l_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%type;

Line 718: ra_cust_trx_types.natural_application_only_flag%type;

714: l_creation_sign ra_cust_trx_types.creation_sign%type;
715: l_allow_overapplication_flag
716: ra_cust_trx_types.allow_overapplication_flag%type;
717: l_natural_app_only_flag
718: ra_cust_trx_types.natural_application_only_flag%type;
719:
720: l_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%type;
721: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
722:

Line 720: l_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%type;

716: ra_cust_trx_types.allow_overapplication_flag%type;
717: l_natural_app_only_flag
718: ra_cust_trx_types.natural_application_only_flag%type;
719:
720: l_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%type;
721: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
722:
723:
724: l_trx_gl_date ra_cust_trx_line_gl_dist.gl_date%type;

Line 721: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;

717: l_natural_app_only_flag
718: ra_cust_trx_types.natural_application_only_flag%type;
719:
720: l_open_receivables_flag ra_cust_trx_types.accounting_affect_flag%type;
721: l_tax_calculation_flag ra_cust_trx_types.tax_calculation_flag%type;
722:
723:
724: l_trx_gl_date ra_cust_trx_line_gl_dist.gl_date%type;
725: l_commit_gl_date ra_cust_trx_line_gl_dist.gl_date%type;

Line 881: FROM ra_cust_trx_types

877: tax_calculation_flag
878: INTO l_class,
879: l_creation_sign,
880: l_tax_calculation_flag
881: FROM ra_cust_trx_types
882: WHERE cust_trx_type_id = l_trx_rec.cust_trx_type_id;
883:
884: SELECT lgd_trx.gl_date,
885: lgd_trx.amount

Line 1579: FROM ra_cust_trx_types

1575: INTO l_allow_overapplication_flag,
1576: l_natural_app_only_flag,
1577: l_open_receivables_flag,
1578: l_credited_class
1579: FROM ra_cust_trx_types
1580: WHERE cust_trx_type_id = l_prev_trx_rec.cust_trx_type_id;
1581:
1582:
1583: /*--------------------------------------+