APPS.PAY_IE_PENSION_TEMPLATE dependencies on PAY_ELEMENT_TYPES_F

Line 123: from pay_element_types_f

119: l_proc_name Varchar2(72) := g_proc_name || 'get_object_id';
120: --
121: cursor c2 (c_object_name varchar2) is
122: select element_type_id
123: from pay_element_types_f
124: where element_name = c_object_name
125: and business_group_id = p_business_group_id;
126: --
127: cursor c3 (c_object_name in Varchar2) is

Line 217: FROM pay_element_types_f

213:
214: CURSOR c_ele_id (c_name IN VARCHAR2)
215: IS
216: SELECT element_type_id
217: FROM pay_element_types_f
218: WHERE element_name = c_name
219: AND trunc(p_scheme_start_date) BETWEEN
220: effective_start_date AND effective_end_date;
221:

Line 373: ,pay_element_types_f pet

369: select input_value_id
370: ,piv.name
371: ,piv.element_type_id
372: from pay_input_values_f piv
373: ,pay_element_types_f pet
374: where element_name = c_ele_name
375: and piv.element_type_id = pet.element_type_id
376: and (piv.business_group_id = p_business_group_id or
377: piv.business_group_id is null)

Line 451: l_object_version_number pay_element_types_f.object_version_number%type;

447: l_setup_element_type_id pay_template_core_objects.core_object_id%type;
448: l_er_base_element_type_id pay_template_core_objects.core_object_id%type;
449: l_ee_tax_element_type_id pay_template_core_objects.core_object_id%type;
450: l_source_template_id pay_element_templates.template_id%type;
451: l_object_version_number pay_element_types_f.object_version_number%type;
452: l_proc_name Varchar2(80) := g_proc_name || 'create_user_template';
453: l_element_type_id Number;
454: l_balance_type_id Number;
455: l_eei_element_type_id Number;

Line 496: type t_ele_name is table of pay_element_types_f.element_name%type

492: type t_shadow_ele_info is table of shadow_ele_rec
493: index by Binary_Integer;
494: l_shadow_element t_shadow_ele_info;
495:
496: type t_ele_name is table of pay_element_types_f.element_name%type
497: index by BINARY_INTEGER;
498: l_ele_name t_ele_name;
499: l_ele_new_name t_ele_name;
500: l_main_ele_name t_ele_name;

Line 508: type t_ele_reporting_name is table of pay_element_types_f.reporting_name%type

504: index by BINARY_INTEGER;
505: l_bal_name t_bal_name;
506: l_bal_new_name t_bal_name;
507:
508: type t_ele_reporting_name is table of pay_element_types_f.reporting_name%type
509: index by BINARY_INTEGER;
510: l_ele_reporting_name t_ele_reporting_name;
511:
512: type t_ele_description is table of pay_element_types_f.description%type

Line 512: type t_ele_description is table of pay_element_types_f.description%type

508: type t_ele_reporting_name is table of pay_element_types_f.reporting_name%type
509: index by BINARY_INTEGER;
510: l_ele_reporting_name t_ele_reporting_name;
511:
512: type t_ele_description is table of pay_element_types_f.description%type
513: index by BINARY_INTEGER;
514: l_ele_description t_ele_description;
515:
516: type t_ele_pp is table of pay_element_types_f.processing_priority%type

Line 516: type t_ele_pp is table of pay_element_types_f.processing_priority%type

512: type t_ele_description is table of pay_element_types_f.description%type
513: index by BINARY_INTEGER;
514: l_ele_description t_ele_description;
515:
516: type t_ele_pp is table of pay_element_types_f.processing_priority%type
517: index by BINARY_INTEGER;
518: l_ele_pp t_ele_pp;
519:
520: type t_eei_info is table of pay_element_type_extra_info.eei_information1%type