APPS.ARP_STAX_MINUS99 dependencies on RA_CUSTOMER_TRX_LINES

Line 694: from ra_customer_trx_lines l

690: CURSOR RateUsed( p_sales_tax_id IN NUMBER ) IS
691: SELECT 'x' from dual
692: WHERE exists (
693: select 'x'
694: from ra_customer_trx_lines l
695: where l.sales_tax_id = p_sales_tax_id );
696: --
697: dummy varchar2(30);
698: --

Line 979: from ra_customer_trx_lines l

975: CURSOR PurgeRateUsed( p_sales_tax_id IN NUMBER ) IS
976: SELECT 'x' from dual
977: WHERE exists (
978: select 'x'
979: from ra_customer_trx_lines l
980: where l.sales_tax_id = p_sales_tax_id );
981: --
982: dummy varchar2(30);
983: --

Line 1051: | MODIFIES: RA_CUSTOMER_TRX_LINES.LINE_NUMBER |

1047: | recalculated. |
1048: | |
1049: | REQUIRES: CUSTOMER_TRX_ID |
1050: | |
1051: | MODIFIES: RA_CUSTOMER_TRX_LINES.LINE_NUMBER |
1052: | |
1053: +-------------------------------------------------------------------------*/
1054:
1055: PROCEDURE renumber_tax_lines( customer_trx_id in number,

Line 1061: from ra_customer_trx_lines

1057: cursor c_tax_lines( cust_trx_id in number, cust_trx_type in varchar2 ) is
1058: select customer_trx_line_id,
1059: line_number,
1060: link_to_cust_trx_line_id
1061: from ra_customer_trx_lines
1062: where customer_trx_id = cust_trx_id
1063: and line_type = cust_trx_type
1064: and link_to_cust_trx_line_id is not null
1065: order by link_to_cust_trx_line_id, customer_trx_line_id

Line 1085: update ra_customer_trx_lines set line_number = new_line_number

1081: trx_line.link_to_cust_trx_line_id;
1082: new_line_number := 0;
1083: end if;
1084: new_line_number := new_line_number + 1;
1085: update ra_customer_trx_lines set line_number = new_line_number
1086: where current of c_tax_lines;
1087: end loop;
1088:
1089: END;