APPS.PN_EXP_TO_AR dependencies on RA_TERMS

Line 43: FROM ra_terms

39: WHERE cust_trx_type_id = p_cust_trx_type_id;
40:
41: CURSOR get_term_name (p_term_id number) is
42: SELECT name
43: FROM ra_terms
44: WHERE term_id = p_term_id;
45:
46: CURSOR get_loc_code(p_location_id number) is
47: SELECT pl.location_code

Line 577: l_term_name RA_TERMS.NAME%TYPE;

573: l_desc RA_INTERFACE_LINES.description%TYPE;
574: l_salesrep_number RA_SALESREPS.SALESREP_NUMBER%TYPE;
575: l_sales_credit_id RA_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE;
576: l_cust_trx_name RA_CUST_TRX_TYPES.NAME%TYPE;
577: l_term_name RA_TERMS.NAME%TYPE;
578: l_pay_method_name AR_RECEIPT_METHODS.NAME%TYPE;
579: l_amt NUMBER;
580: l_prior_payment_schedule_id NUMBER := -999;
581: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;

Line 1875: l_term_name RA_TERMS.name%TYPE;

1871: l_desc RA_INTERFACE_LINES.description%TYPE;
1872: l_salesrep_number RA_SALESREPS.salesrep_number%TYPE;
1873: l_sales_credit_id RA_SALESREPS.sales_credit_type_id%TYPE;
1874: l_cust_trx_name RA_CUST_TRX_TYPES.name%TYPE;
1875: l_term_name RA_TERMS.name%TYPE;
1876: l_pay_method_name AR_RECEIPT_METHODS.name%TYPE;
1877: l_amt NUMBER;
1878: l_prior_payment_schedule_id NUMBER := -999;
1879: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;