APPS.ARP_PROCESS_CREDIT_UTIL dependencies on RA_SALESREPS

Line 1023: ra_salesreps.salesrep_id%type,

1019: hz_cust_site_uses.site_use_id%type,
1020: p_bill_to_contact_id IN
1021: hz_cust_account_roles.cust_account_role_id%type,
1022: p_primary_salesrep_id IN
1023: ra_salesreps.salesrep_id%type,
1024: p_receipt_method_id IN
1025: ar_receipt_methods.receipt_method_id%type,
1026: p_customer_bank_account_id IN
1027: ce_bank_accounts.bank_account_id%type,

Line 1075: ra_salesreps.salesrep_id%type,

1071: hz_cust_site_uses.site_use_id%type,
1072: p_crtrx_bill_to_contact_id IN
1073: hz_cust_account_roles.cust_account_role_id%type,
1074: p_crtrx_primary_salesrep_id IN
1075: ra_salesreps.salesrep_id%type,
1076: p_crtrx_open_rec_flag IN
1077: ra_cust_trx_types.accounting_affect_flag%type,
1078: --
1079: p_crtrx_receipt_method_id IN

Line 1140: ra_salesreps.salesrep_id%type,

1136: hz_cust_site_uses.site_use_id%type,
1137: p_default_bill_to_contact_id OUT NOCOPY
1138: hz_cust_account_roles.cust_account_role_id%type,
1139: p_default_primary_salesrep_id OUT NOCOPY
1140: ra_salesreps.salesrep_id%type,
1141: p_default_receipt_method_id OUT NOCOPY
1142: ar_receipt_methods.receipt_method_id%type,
1143: p_default_cust_bank_account_id OUT NOCOPY
1144: ce_bank_accounts.bank_account_id%type,

Line 1176: l_primary_salesrep_id ra_salesreps.salesrep_id%type;

1172: l_bill_to_customer_id hz_cust_accounts.cust_account_id%type;
1173: l_bill_to_site_use_id hz_cust_site_uses.site_use_id%type;
1174: l_ship_to_site_use_id hz_cust_site_uses.site_use_id%type; --4766915
1175: l_ship_to_contact_id hz_cust_account_roles.cust_account_role_id%type;
1176: l_primary_salesrep_id ra_salesreps.salesrep_id%type;
1177: l_number_of_due_dates number;
1178: l_term_due_date date;
1179: l_default_class ra_cust_trx_types.type%type;
1180: l_post_to_gl_flag ra_cust_trx_types.post_to_gl%type;

Line 1586: FROM ra_salesreps s,

1582: BEGIN
1583: /* modified for tca uptake */
1584: SELECT s.salesrep_id
1585: INTO l_primary_salesrep_id
1586: FROM ra_salesreps s,
1587: hz_cust_site_uses site_uses
1588: WHERE s.salesrep_id = site_uses.primary_salesrep_id
1589: AND site_uses.site_use_id = l_bill_to_site_use_id
1590: AND p_trx_date BETWEEN nvl(start_date_active, p_trx_date)

Line 1610: FROM ra_salesreps s,

1606: BEGIN
1607: /* modified for tca uptake */
1608: SELECT s.salesrep_id
1609: INTO l_primary_salesrep_id
1610: FROM ra_salesreps s,
1611: hz_cust_site_uses site_uses
1612: WHERE s.salesrep_id = site_uses.primary_salesrep_id
1613: AND site_uses.site_use_id = l_ship_to_site_use_id
1614: AND p_trx_date BETWEEN nvl(start_date_active, p_trx_date)