APPS.JTF_RS_CONC_RES_PUB dependencies on OE_SALES_CREDIT_TYPES

Line 318: l_sales_credit_type oe_sales_credit_types.name%TYPE;

314: l_salesperson_number jtf_rs_salesreps.salesrep_number%TYPE;
315: l_role_id jtf_rs_roles_vl.role_id%TYPE;
316: l_role_name jtf_rs_roles_vl.role_name%TYPE;
317: /* Moved the initial assignment of below variable to inside begin */
318: l_sales_credit_type oe_sales_credit_types.name%TYPE;
319: l_sales_credit_type_id oe_sales_credit_types.sales_credit_type_id%TYPE;
320:
321: /* Moved the initial assignment of below variable to inside begin */
322: l_prof_srp_num fnd_profile_option_values.profile_option_value%TYPE;

Line 319: l_sales_credit_type_id oe_sales_credit_types.sales_credit_type_id%TYPE;

315: l_role_id jtf_rs_roles_vl.role_id%TYPE;
316: l_role_name jtf_rs_roles_vl.role_name%TYPE;
317: /* Moved the initial assignment of below variable to inside begin */
318: l_sales_credit_type oe_sales_credit_types.name%TYPE;
319: l_sales_credit_type_id oe_sales_credit_types.sales_credit_type_id%TYPE;
320:
321: /* Moved the initial assignment of below variable to inside begin */
322: l_prof_srp_num fnd_profile_option_values.profile_option_value%TYPE;
323: l_prof_get_emp_org fnd_profile_option_values.profile_option_value%TYPE;

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

356: WHERE role_id = l_role_id;
357:
358: l_role_type_code jtf_rs_roles_b.role_type_code%TYPE;
359:
360: CURSOR c_sales_credit_type_id (l_sales_credit_type oe_sales_credit_types.name%TYPE) IS
361: SELECT sales_credit_type_id
362: FROM oe_sales_credit_types
363: WHERE name = l_sales_credit_type;
364:

Line 362: FROM oe_sales_credit_types

358: l_role_type_code jtf_rs_roles_b.role_type_code%TYPE;
359:
360: CURSOR c_sales_credit_type_id (l_sales_credit_type oe_sales_credit_types.name%TYPE) IS
361: SELECT sales_credit_type_id
362: FROM oe_sales_credit_types
363: WHERE name = l_sales_credit_type;
364:
365: -- End of Variables and Cursors Added
366: