APPS.PAY_IE_PENSION_TEMPLATE dependencies on PAY_ELEMENT_TYPES_F

Line 132: from pay_element_types_f

128: l_proc_name Varchar2(72) := g_proc_name || 'get_object_id';
129: --
130: cursor c2 (c_object_name varchar2) is
131: select element_type_id
132: from pay_element_types_f
133: where element_name = c_object_name
134: and business_group_id = p_business_group_id;
135: --
136: cursor c3 (c_object_name in Varchar2) is

Line 226: FROM pay_element_types_f

222:
223: CURSOR c_ele_id (c_name IN VARCHAR2)
224: IS
225: SELECT element_type_id
226: FROM pay_element_types_f
227: WHERE element_name = c_name
228: AND trunc(p_scheme_start_date) BETWEEN
229: effective_start_date AND effective_end_date;
230:

Line 382: ,pay_element_types_f pet

378: select input_value_id
379: ,piv.name
380: ,piv.element_type_id
381: from pay_input_values_f piv
382: ,pay_element_types_f pet
383: where element_name = c_ele_name
384: and piv.element_type_id = pet.element_type_id
385: and (piv.business_group_id = p_business_group_id or
386: piv.business_group_id is null)

Line 460: l_object_version_number pay_element_types_f.object_version_number%type;

456: l_setup_element_type_id pay_template_core_objects.core_object_id%type;
457: l_er_base_element_type_id pay_template_core_objects.core_object_id%type;
458: l_ee_tax_element_type_id pay_template_core_objects.core_object_id%type;
459: l_source_template_id pay_element_templates.template_id%type;
460: l_object_version_number pay_element_types_f.object_version_number%type;
461: l_proc_name Varchar2(80) := g_proc_name || 'create_user_template';
462: l_element_type_id Number;
463: l_balance_type_id Number;
464: l_eei_element_type_id Number;

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

501: type t_shadow_ele_info is table of shadow_ele_rec
502: index by Binary_Integer;
503: l_shadow_element t_shadow_ele_info;
504:
505: type t_ele_name is table of pay_element_types_f.element_name%type
506: index by BINARY_INTEGER;
507: l_ele_name t_ele_name;
508: l_ele_new_name t_ele_name;
509: l_main_ele_name t_ele_name;

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

513: index by BINARY_INTEGER;
514: l_bal_name t_bal_name;
515: l_bal_new_name t_bal_name;
516:
517: type t_ele_reporting_name is table of pay_element_types_f.reporting_name%type
518: index by BINARY_INTEGER;
519: l_ele_reporting_name t_ele_reporting_name;
520:
521: type t_ele_description is table of pay_element_types_f.description%type

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

517: type t_ele_reporting_name is table of pay_element_types_f.reporting_name%type
518: index by BINARY_INTEGER;
519: l_ele_reporting_name t_ele_reporting_name;
520:
521: type t_ele_description is table of pay_element_types_f.description%type
522: index by BINARY_INTEGER;
523: l_ele_description t_ele_description;
524:
525: type t_ele_pp is table of pay_element_types_f.processing_priority%type

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

521: type t_ele_description is table of pay_element_types_f.description%type
522: index by BINARY_INTEGER;
523: l_ele_description t_ele_description;
524:
525: type t_ele_pp is table of pay_element_types_f.processing_priority%type
526: index by BINARY_INTEGER;
527: l_ele_pp t_ele_pp;
528:
529: type t_eei_info is table of pay_element_type_extra_info.eei_information1%type