APPS.PN_EXP_TO_AR dependencies on RA_SALESREPS

Line 32: FROM ra_salesreps

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
32: FROM ra_salesreps
33: WHERE salesrep_id = p_salesrep_id
34: AND org_id = p_org_id;
35:
36: CURSOR get_cust_trx_name (p_cust_trx_type_id number) is

Line 73: WHERE seg.table_name = 'RA_SALESREPS'

69: CURSOR gl_segment_check IS
70: SELECT 'Y'
71: FROM ra_account_defaults def,
72: ra_account_default_segments seg
73: WHERE seg.table_name = 'RA_SALESREPS'
74: AND def.gl_default_id = seg.gl_default_id
75: AND def.type = 'REV';
76:
77: CURSOR sys_param_check IS

Line 574: l_salesrep_number RA_SALESREPS.SALESREP_NUMBER%TYPE;

570: l_acc_rule_name RA_RULES.NAME%TYPE;
571: l_acc_rule_type RA_RULES.TYPE%TYPE;
572: l_acc_rule_freq RA_RULES.FREQUENCY%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;

Line 575: l_sales_credit_id RA_SALESREPS.SALES_CREDIT_TYPE_ID%TYPE;

571: l_acc_rule_type RA_RULES.TYPE%TYPE;
572: l_acc_rule_freq RA_RULES.FREQUENCY%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;

Line 1872: l_salesrep_number RA_SALESREPS.salesrep_number%TYPE;

1868: l_acc_rule_name RA_RULES.name%TYPE;
1869: l_acc_rule_type RA_RULES.type%TYPE;
1870: l_acc_rule_freq RA_RULES.frequency%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;

Line 1873: l_sales_credit_id RA_SALESREPS.sales_credit_type_id%TYPE;

1869: l_acc_rule_type RA_RULES.type%TYPE;
1870: l_acc_rule_freq RA_RULES.frequency%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;