APPS.JTF_RS_CONC_RES_PUB dependencies on OE_SALES_CREDIT_TYPES

Line 260: l_sales_credit_type oe_sales_credit_types.name%TYPE;

256: l_salesperson_number jtf_rs_salesreps.salesrep_number%TYPE;
257: l_role_id jtf_rs_roles_vl.role_id%TYPE;
258: l_role_name jtf_rs_roles_vl.role_name%TYPE;
259: /* Moved the initial assignment of below variable to inside begin */
260: l_sales_credit_type oe_sales_credit_types.name%TYPE;
261: l_sales_credit_type_id oe_sales_credit_types.sales_credit_type_id%TYPE;
262:
263: /* Moved the initial assignment of below variable to inside begin */
264: l_prof_srp_num fnd_profile_option_values.profile_option_value%TYPE;

Line 261: l_sales_credit_type_id oe_sales_credit_types.sales_credit_type_id%TYPE;

257: l_role_id jtf_rs_roles_vl.role_id%TYPE;
258: l_role_name jtf_rs_roles_vl.role_name%TYPE;
259: /* Moved the initial assignment of below variable to inside begin */
260: l_sales_credit_type oe_sales_credit_types.name%TYPE;
261: l_sales_credit_type_id oe_sales_credit_types.sales_credit_type_id%TYPE;
262:
263: /* Moved the initial assignment of below variable to inside begin */
264: l_prof_srp_num fnd_profile_option_values.profile_option_value%TYPE;
265: l_prof_get_emp_org fnd_profile_option_values.profile_option_value%TYPE;

Line 302: CURSOR c_sales_credit_type_id (l_sales_credit_type oe_sales_credit_types.name%TYPE) IS

298: WHERE role_id = l_role_id;
299:
300: l_role_type_code jtf_rs_roles_b.role_type_code%TYPE;
301:
302: CURSOR c_sales_credit_type_id (l_sales_credit_type oe_sales_credit_types.name%TYPE) IS
303: SELECT sales_credit_type_id
304: FROM oe_sales_credit_types
305: WHERE name = l_sales_credit_type;
306:

Line 304: FROM oe_sales_credit_types

300: l_role_type_code jtf_rs_roles_b.role_type_code%TYPE;
301:
302: CURSOR c_sales_credit_type_id (l_sales_credit_type oe_sales_credit_types.name%TYPE) IS
303: SELECT sales_credit_type_id
304: FROM oe_sales_credit_types
305: WHERE name = l_sales_credit_type;
306:
307: -- End of Variables and Cursors Added
308: