eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_OSP_TEMPLATE dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 769: TYPE t_eei_info IS TABLE OF pay_element_type_extra_info.eei_information19%

765: INDEX BY BINARY_INTEGER;
766:
767: l_ele_pp t_ele_pp;
768:
769: TYPE t_eei_info IS TABLE OF pay_element_type_extra_info.eei_information19%
770: TYPE
771: INDEX BY BINARY_INTEGER;
772:
773: l_main_eei_info19 t_eei_info;

Line 817: l_eei_information9 pay_element_type_extra_info.eei_information9%

813: l_ele_core_id pay_template_core_objects.core_object_id%TYPE:=
814: -1;
815:
816: -- Extra Information variables
817: l_eei_information9 pay_element_type_extra_info.eei_information9%
818: TYPE;
819: l_eei_information10 pay_element_type_extra_info.eei_information10%
820: TYPE;
821: l_eei_information18 pay_element_type_extra_info.eei_information18%

Line 819: l_eei_information10 pay_element_type_extra_info.eei_information10%

815:
816: -- Extra Information variables
817: l_eei_information9 pay_element_type_extra_info.eei_information9%
818: TYPE;
819: l_eei_information10 pay_element_type_extra_info.eei_information10%
820: TYPE;
821: l_eei_information18 pay_element_type_extra_info.eei_information18%
822: TYPE;
823:

Line 821: l_eei_information18 pay_element_type_extra_info.eei_information18%

817: l_eei_information9 pay_element_type_extra_info.eei_information9%
818: TYPE;
819: l_eei_information10 pay_element_type_extra_info.eei_information10%
820: TYPE;
821: l_eei_information18 pay_element_type_extra_info.eei_information18%
822: TYPE;
823:
824: l_eei_information30 pay_element_type_extra_info.eei_information30%
825: TYPE :='Sickness'; -- 'S';--ickness'; -- used to be Sickness Previously

Line 824: l_eei_information30 pay_element_type_extra_info.eei_information30%

820: TYPE;
821: l_eei_information18 pay_element_type_extra_info.eei_information18%
822: TYPE;
823:
824: l_eei_information30 pay_element_type_extra_info.eei_information30%
825: TYPE :='Sickness'; -- 'S';--ickness'; -- used to be Sickness Previously
826:
827:
828: l_eei_information29 pay_element_type_extra_info.eei_information29%

Line 828: l_eei_information29 pay_element_type_extra_info.eei_information29%

824: l_eei_information30 pay_element_type_extra_info.eei_information30%
825: TYPE :='Sickness'; -- 'S';--ickness'; -- used to be Sickness Previously
826:
827:
828: l_eei_information29 pay_element_type_extra_info.eei_information29%
829: TYPE := 'OCCUPATIONAL';
830:
831: l_eei_information28 pay_element_type_extra_info.eei_information28%
832: TYPE := 'PQP_GAP_ENTITLEMENT_BANDS';

Line 831: l_eei_information28 pay_element_type_extra_info.eei_information28%

827:
828: l_eei_information29 pay_element_type_extra_info.eei_information29%
829: TYPE := 'OCCUPATIONAL';
830:
831: l_eei_information28 pay_element_type_extra_info.eei_information28%
832: TYPE := 'PQP_GAP_ENTITLEMENT_BANDS';
833:
834: l_eei_information27 pay_element_type_extra_info.eei_information27%
835: TYPE := 'PQP_GB_OSP_CALENDAR_RULES';

Line 834: l_eei_information27 pay_element_type_extra_info.eei_information27%

830:
831: l_eei_information28 pay_element_type_extra_info.eei_information28%
832: TYPE := 'PQP_GAP_ENTITLEMENT_BANDS';
833:
834: l_eei_information27 pay_element_type_extra_info.eei_information27%
835: TYPE := 'PQP_GB_OSP_CALENDAR_RULES';
836:
837:
838: l_eei_information20 pay_element_type_extra_info.eei_information29%

Line 838: l_eei_information20 pay_element_type_extra_info.eei_information29%

834: l_eei_information27 pay_element_type_extra_info.eei_information27%
835: TYPE := 'PQP_GB_OSP_CALENDAR_RULES';
836:
837:
838: l_eei_information20 pay_element_type_extra_info.eei_information29%
839: TYPE := p_dual_rolling_duration ; --'4';
840:
841:
842: l_eei_information21 pay_element_type_extra_info.eei_information29%

Line 842: l_eei_information21 pay_element_type_extra_info.eei_information29%

838: l_eei_information20 pay_element_type_extra_info.eei_information29%
839: TYPE := p_dual_rolling_duration ; --'4';
840:
841:
842: l_eei_information21 pay_element_type_extra_info.eei_information29%
843: TYPE := p_dual_rolling_UOM ; --'YEARS';
844:
845:
846: l_eei_information22 pay_element_type_extra_info.eei_information22%

Line 846: l_eei_information22 pay_element_type_extra_info.eei_information22%

842: l_eei_information21 pay_element_type_extra_info.eei_information29%
843: TYPE := p_dual_rolling_UOM ; --'YEARS';
844:
845:
846: l_eei_information22 pay_element_type_extra_info.eei_information22%
847: TYPE := p_enable_ent_proration ; -- LG
848: l_eei_information23 pay_element_type_extra_info.eei_information23%
849: TYPE := p_abs_schedule_wp ; -- LG
850: l_eei_information24 pay_element_type_extra_info.eei_information24%

Line 848: l_eei_information23 pay_element_type_extra_info.eei_information23%

844:
845:
846: l_eei_information22 pay_element_type_extra_info.eei_information22%
847: TYPE := p_enable_ent_proration ; -- LG
848: l_eei_information23 pay_element_type_extra_info.eei_information23%
849: TYPE := p_abs_schedule_wp ; -- LG
850: l_eei_information24 pay_element_type_extra_info.eei_information24%
851: TYPE := p_plan_type_lookup_type ; -- LG
852: l_eei_information14 pay_element_type_extra_info.eei_information14%

Line 850: l_eei_information24 pay_element_type_extra_info.eei_information24%

846: l_eei_information22 pay_element_type_extra_info.eei_information22%
847: TYPE := p_enable_ent_proration ; -- LG
848: l_eei_information23 pay_element_type_extra_info.eei_information23%
849: TYPE := p_abs_schedule_wp ; -- LG
850: l_eei_information24 pay_element_type_extra_info.eei_information24%
851: TYPE := p_plan_type_lookup_type ; -- LG
852: l_eei_information14 pay_element_type_extra_info.eei_information14%
853: TYPE := p_ft_round_config ;
854: l_eei_information25 pay_element_type_extra_info.eei_information25%

Line 852: l_eei_information14 pay_element_type_extra_info.eei_information14%

848: l_eei_information23 pay_element_type_extra_info.eei_information23%
849: TYPE := p_abs_schedule_wp ; -- LG
850: l_eei_information24 pay_element_type_extra_info.eei_information24%
851: TYPE := p_plan_type_lookup_type ; -- LG
852: l_eei_information14 pay_element_type_extra_info.eei_information14%
853: TYPE := p_ft_round_config ;
854: l_eei_information25 pay_element_type_extra_info.eei_information25%
855: TYPE := p_pt_round_config ;
856:

Line 854: l_eei_information25 pay_element_type_extra_info.eei_information25%

850: l_eei_information24 pay_element_type_extra_info.eei_information24%
851: TYPE := p_plan_type_lookup_type ; -- LG
852: l_eei_information14 pay_element_type_extra_info.eei_information14%
853: TYPE := p_ft_round_config ;
854: l_eei_information25 pay_element_type_extra_info.eei_information25%
855: TYPE := p_pt_round_config ;
856:
857:
858:

Line 883: FROM pay_element_type_extra_info

879: AND balance_name = c_bal_name;
880:
881: CURSOR csr_chk_primary_exists is
882: SELECT 'X'
883: FROM pay_element_type_extra_info
884: WHERE eei_information1 = fnd_number.number_to_canonical(p_plan_id)
885: AND eei_information16 = 'Y'
886: AND information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
887: AND rownum = 1;

Line 3253: l_daily_rate_uom pay_element_type_extra_info.eei_information13%TYPE ;

3249:
3250: -- Added For Hours
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:

Line 3261: FROM pay_element_type_extra_info pee

3257:
3258: CURSOR csr_get_scheme_type(p_ele_type_id IN NUMBER) IS
3259: SELECT pee.eei_information8 entitlements_uom
3260: ,pee.eei_information11 daily_rate_uom
3261: FROM pay_element_type_extra_info pee
3262: WHERE element_type_id = p_ele_type_id
3263: AND information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO' ;
3264:
3265: -- Added For Hours

Line 3284: FROM pay_element_type_extra_info petei

3280: ,fnd_number.canonical_to_number(eei_information9) entitlement_udt
3281: ,fnd_number.canonical_to_number(eei_information10) calendar_udt
3282: ,eei_information18 lookup_type
3283: ,eei_information24 plan_type_lookup
3284: FROM pay_element_type_extra_info petei
3285: WHERE element_type_id = c_element_type_id ;
3286:
3287: CURSOR csr_chk_eei_for_entudt (c_udt_id number)
3288: IS

Line 3290: FROM pay_element_type_extra_info

3286:
3287: CURSOR csr_chk_eei_for_entudt (c_udt_id number)
3288: IS
3289: SELECT 'X'
3290: FROM pay_element_type_extra_info
3291: WHERE eei_information1 <> fnd_number.number_to_canonical(p_plan_id)
3292: AND eei_information9 = fnd_number.number_to_canonical(c_udt_id)
3293: AND information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
3294: AND rownum = 1;

Line 3299: FROM pay_element_type_extra_info

3295:
3296: CURSOR csr_chk_eei_for_caludt (c_udt_id number)
3297: IS
3298: SELECT 'X'
3299: FROM pay_element_type_extra_info
3300: WHERE eei_information1 <> fnd_number.number_to_canonical(p_plan_id)
3301: AND eei_information10 = fnd_number.number_to_canonical(c_udt_id)
3302: AND information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
3303: AND rownum = 1;

Line 3308: FROM pay_element_type_extra_info

3304:
3305: CURSOR csr_chk_eei_for_lkt (c_lookup_type varchar2)
3306: IS
3307: SELECT 'X'
3308: FROM pay_element_type_extra_info
3309: WHERE eei_information1 <> fnd_number.number_to_canonical(p_plan_id)
3310: AND eei_information18 = c_lookup_type
3311: AND information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
3312: AND rownum = 1;

Line 3323: ,pay_element_type_extra_info peei

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
3325: -- For the given user structure
3326: AND pets.template_name = p_template_name -- 'PQP OSP'
3327: AND pets.template_type = 'U'

Line 3391: FROM pay_element_type_extra_info pete

3387:
3388: CURSOR csr_get_lookup_type(c_base_name in varchar2)
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'