APPS.PN_EXP_TO_AR dependencies on AR_RECEIPT_METHODS

Line 27: FROM ar_receipt_methods

23: WHERE rule_id = p_rule_id;
24:
25: CURSOR get_receipt_name (p_receipt_method_id number) is
26: SELECT name
27: FROM ar_receipt_methods
28: WHERE receipt_method_id = p_receipt_method_id;
29:
30: CURSOR get_salesrep_number (p_salesrep_id number, p_org_id NUMBER) is
31: SELECT SALESREP_NUMBER,SALES_CREDIT_TYPE_ID

Line 582: l_pay_method_name AR_RECEIPT_METHODS.NAME%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;
586: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;

Line 1922: l_pay_method_name AR_RECEIPT_METHODS.name%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;
1926: l_last_update_login NUMBER := FND_GLOBAL.LOGIN_ID;