APPS.ARRX_SALES_TAX_REP dependencies on AR_ADJUSTMENTS

Line 572: from ar_adjustments;

568: from ra_customer_trx;
569:
570: select nvl(min(gl_date), trx_date_low_1)
571: into trx_date_low_2
572: from ar_adjustments;
573:
574: if trx_date_low_1 < trx_date_low_2
575: then h_trx_date_low := trx_date_low_1;
576: else h_trx_date_low := trx_date_low_2;

Line 587: from ar_adjustments;

583: from ra_customer_trx;
584:
585: select nvl(max(gl_date), trx_date_high_1)
586: into trx_date_high_2
587: from ar_adjustments;
588:
589: if trx_date_high_1 > trx_date_high_2
590: then h_trx_date_high := trx_date_high_1;
591: else h_trx_date_high := trx_date_high_2;

Line 606: from ar_adjustments;

602:
603: if trx_date_low_2 is null then
604: select nvl(min(gl_date), gl_date_low_1)
605: into gl_date_low_2
606: from ar_adjustments;
607: else gl_date_low_2 := trx_date_low_2;
608: end if;
609:
610: if gl_date_low_1 < gl_date_low_2

Line 624: from ar_adjustments;

620:
621: if trx_date_high_2 is null then
622: select nvl(max(gl_date), gl_date_high_1)
623: into gl_date_high_2
624: from ar_adjustments;
625: else gl_date_high_2 := trx_date_high_2;
626: end if;
627:
628: if gl_date_high_1 > gl_date_high_2

Line 716: 'FROM gl_code_combinations cc, ar_adjustments adj, hz_cust_accounts c, hz_parties party, ar_vat_tax vat, '||

712: 'gl_code_combinations gltax, ra_cust_trx_line_gl_dist dist, '||
713: 'ra_customer_trx trx ';
714:
715: select_adj_from :=
716: 'FROM gl_code_combinations cc, ar_adjustments adj, hz_cust_accounts c, hz_parties party, ar_vat_tax vat, '||
717: 'ra_tax_exemptions ex, ar_lookups lk2, ar_lookups lk3, fnd_currencies cy, '||
718: 'ra_customer_trx_lines line, ra_customer_trx_lines tax, ra_customer_trx trx, '||
719: 'hz_cust_site_uses su, hz_cust_acct_sites acct_site, ' ||
720: 'hz_locations loc, hz_loc_assignments loc_assign, hz_party_sites party_site ';

Line 736: 'hz_locations loc, hz_loc_assignments loc_assign, gl_code_combinations cc, ar_adjustments adj ';

732: 'FROM hz_cust_accounts c, hz_parties party, ar_vat_tax vat, '||
733: 'ra_tax_exemptions ex, ar_lookups lk2, ar_lookups lk3, fnd_currencies cy, '||
734: 'ra_customer_trx_lines line, ra_customer_trx_lines tax, ra_customer_trx trx, '||
735: 'hz_cust_site_uses su, hz_cust_acct_sites acct_site, hz_party_sites party_site, ' ||
736: 'hz_locations loc, hz_loc_assignments loc_assign, gl_code_combinations cc, ar_adjustments adj ';
737: END IF;
738:
739: select_statement := select_trx_cols ||
740: select_trx_from ||

Line 1482: total_adjust_amount ar_adjustments.line_adjusted%TYPE;

1478: c_adj_line_amount IN NUMBER)
1479: RETURN NUMBER is
1480:
1481: calc_amount NUMBER;
1482: total_adjust_amount ar_adjustments.line_adjusted%TYPE;
1483: abs_total number;
1484: count_lines number;
1485: line_amount number;
1486:

Line 1538: total_adjust_amount ar_adjustments.line_adjusted%TYPE;

1534: RETURN NUMBER is
1535:
1536:
1537: calc_amount ra_customer_trx_lines.extended_amount%TYPE;
1538: total_adjust_amount ar_adjustments.line_adjusted%TYPE;
1539: count_lines number;
1540: abs_total number;
1541: tax_amount number;
1542: