DBA Data[Home] [Help]

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

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