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 581: l_term_name RA_TERMS.NAME%TYPE;

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

Line 1921: l_term_name RA_TERMS.name%TYPE;

1917: l_desc RA_INTERFACE_LINES.description%TYPE;
1918: l_salesrep_number RA_SALESREPS.salesrep_number%TYPE;
1919: l_sales_credit_id RA_SALESREPS.sales_credit_type_id%TYPE;
1920: l_cust_trx_name RA_CUST_TRX_TYPES.name%TYPE;
1921: l_term_name RA_TERMS.name%TYPE;
1922: l_pay_method_name AR_RECEIPT_METHODS.name%TYPE;
1923: l_amt NUMBER;
1924: l_prior_payment_schedule_id NUMBER := -999;
1925: l_last_updated_by NUMBER := FND_GLOBAL.USER_ID;