APPS.PQP_GB_OSP_TEMPLATE dependencies on PAY_ELEMENT_TEMPLATES

Line 707: l_source_template_id pay_element_templates.template_id%TYPE;

703:
704:
705: l_template_id pay_shadow_element_types.template_id%TYPE;
706: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
707: l_source_template_id pay_element_templates.template_id%TYPE;
708: l_object_version_number pay_element_types_f.object_version_number%TYPE;
709:
710: l_proc_step NUMBER(20,10);
711: l_proc_name VARCHAR2(80) :=

Line 729: l_base_name pay_element_templates.base_name%TYPE

725: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;
726: l_lookup_meaning fnd_lookup_types_vl.meaning%TYPE;
727: l_exists VARCHAR2(1);
728: l_display_sequence NUMBER;
729: l_base_name pay_element_templates.base_name%TYPE
730: := UPPER(TRANSLATE(TRIM(p_abs_ele_name),' ','_'));
731:
732: l_exc_sec_days_bf VARCHAR2(1);
733:

Line 735: l_template_name pay_element_templates.template_name%TYPE ;

731:
732: l_exc_sec_days_bf VARCHAR2(1);
733:
734: l_days_hours VARCHAR2(10) ; -- Added For Hours
735: l_template_name pay_element_templates.template_name%TYPE ;
736: l_configuration_information2 pay_element_templates.configuration_information2%TYPE;
737:
738:
739: TYPE t_ele_name IS TABLE OF pay_element_types_f.element_name%TYPE

Line 736: l_configuration_information2 pay_element_templates.configuration_information2%TYPE;

732: l_exc_sec_days_bf VARCHAR2(1);
733:
734: l_days_hours VARCHAR2(10) ; -- Added For Hours
735: l_template_name pay_element_templates.template_name%TYPE ;
736: l_configuration_information2 pay_element_templates.configuration_information2%TYPE;
737:
738:
739: TYPE t_ele_name IS TABLE OF pay_element_types_f.element_name%TYPE
740: INDEX BY BINARY_INTEGER;

Line 904: FROM pay_element_templates

900: l_proc_name VARCHAR2(72) := g_package_name || 'get_template_id';
901: --
902: CURSOR csr_get_temp_id is
903: SELECT template_id
904: FROM pay_element_templates
905: WHERE template_name = l_template_name
906: AND legislation_code = p_legislation_code
907: AND template_type = 'T'
908: AND business_group_id is NULL;

Line 3255: l_template_name pay_element_templates.template_name%TYPE ;

3251:
3252: l_entitlements_uom VARCHAR2(1) ;
3253: l_daily_rate_uom pay_element_type_extra_info.eei_information13%TYPE ;
3254: l_days_hours VARCHAR2(10) ;
3255: l_template_name pay_element_templates.template_name%TYPE ;
3256:
3257:
3258: CURSOR csr_get_scheme_type(p_ele_type_id IN NUMBER) IS
3259: SELECT pee.eei_information8 entitlements_uom

Line 3320: FROM pay_element_templates pets

3316: ,p_template_name VARCHAR2
3317: ,p_days_hours VARCHAR2
3318: ) IS
3319: SELECT 'X'
3320: FROM pay_element_templates pets
3321: ,pay_shadow_element_types pset
3322: ,pay_template_core_objects ptco
3323: ,pay_element_type_extra_info peei
3324: WHERE pets.template_id <> c_te_usrstr_id

Line 3341: FROM pay_element_templates

3337: -- find the eei info
3338:
3339: CURSOR csr_get_template_id (p_template_name IN VARCHAR2) is
3340: SELECT template_id
3341: FROM pay_element_templates
3342: WHERE base_name = p_abs_ele_name
3343: AND template_name = p_template_name --'PQP OSP'
3344: AND business_group_id = p_business_group_id
3345: AND template_type = 'U';

Line 3393: -- ,pay_element_templates pet

3389: IS
3390: SELECT DISTINCT(pete.eei_information18) lookup_type
3391: FROM pay_element_type_extra_info pete
3392: ,pay_element_types_f petf
3393: -- ,pay_element_templates pet
3394: WHERE pete.element_type_id = petf.element_type_id
3395: AND pete.information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
3396: AND pete.eei_information16 = 'Y'
3397: AND petf.element_name = c_base_name || ' OSP '||p_days_hours||'Absence'

Line 3407: FROM pay_element_templates pet

3403: ;
3404:
3405: CURSOR csr_template_names IS
3406: SELECT pet.base_name
3407: FROM pay_element_templates pet
3408: WHERE pet.template_name = p_template_name
3409: AND pet.template_type = 'U'
3410: AND pet.business_group_id = p_business_group_id ;
3411:

Line 3418: l_base_name pay_element_templates.base_name%TYPE ;

3414: l_lookup_code fnd_lookup_values_vl.lookup_code%TYPE;
3415: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;
3416: l_proc_step NUMBER(20,10);
3417: l_proc_name VARCHAR2(72) := g_package_name || 'get_other_lookups';
3418: l_base_name pay_element_templates.base_name%TYPE ;
3419:
3420: --
3421: BEGIN
3422: