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_UNPAID_TEMPLATE dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

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

22: TYPE t_ele_pp IS TABLE OF pay_element_types_f.processing_priority%TYPE
23: INDEX BY BINARY_INTEGER;
24:
25:
26: TYPE t_eei_info IS TABLE OF pay_element_type_extra_info.eei_information19%
27: TYPE
28: INDEX BY BINARY_INTEGER;
29:
30: TYPE r_udt_type IS RECORD

Line 876: l_eei_info_id pay_element_type_extra_info.

872: l_eei_element_type_id pay_element_types_f.element_type_id%TYPE;
873: l_ele_obj_ver_number pay_element_types_f.object_version_number%TYPE;
874: l_bal_obj_ver_number pay_element_types_f.object_version_number%TYPE;
875: i NUMBER;
876: l_eei_info_id pay_element_type_extra_info.
877: element_type_extra_info_id%TYPE ;
878: l_ovn_eei pay_element_types_f.object_version_number%TYPE;
879: l_abs_ele_correction_pp NUMBER := p_abs_ele_processing_priority - 50;
880: l_pay_ele_correction_pp NUMBER := p_pay_ele_processing_priority - 50;

Line 924: l_eei_information9 pay_element_type_extra_info.eei_information9%

920: l_ele_core_id pay_template_core_objects.core_object_id%TYPE:=
921: -1;
922:
923: -- Extra Information variables
924: l_eei_information9 pay_element_type_extra_info.eei_information9%
925: TYPE;
926: l_eei_information10 pay_element_type_extra_info.eei_information10%
927: TYPE;
928: l_eei_information18 pay_element_type_extra_info.eei_information18%

Line 926: l_eei_information10 pay_element_type_extra_info.eei_information10%

922:
923: -- Extra Information variables
924: l_eei_information9 pay_element_type_extra_info.eei_information9%
925: TYPE;
926: l_eei_information10 pay_element_type_extra_info.eei_information10%
927: TYPE;
928: l_eei_information18 pay_element_type_extra_info.eei_information18%
929: TYPE;
930: l_eei_information30 pay_element_type_extra_info.eei_information30%

Line 928: l_eei_information18 pay_element_type_extra_info.eei_information18%

924: l_eei_information9 pay_element_type_extra_info.eei_information9%
925: TYPE;
926: l_eei_information10 pay_element_type_extra_info.eei_information10%
927: TYPE;
928: l_eei_information18 pay_element_type_extra_info.eei_information18%
929: TYPE;
930: l_eei_information30 pay_element_type_extra_info.eei_information30%
931: TYPE :='UNPAID';
932: l_eei_information29 pay_element_type_extra_info.eei_information29%

Line 930: l_eei_information30 pay_element_type_extra_info.eei_information30%

926: l_eei_information10 pay_element_type_extra_info.eei_information10%
927: TYPE;
928: l_eei_information18 pay_element_type_extra_info.eei_information18%
929: TYPE;
930: l_eei_information30 pay_element_type_extra_info.eei_information30%
931: TYPE :='UNPAID';
932: l_eei_information29 pay_element_type_extra_info.eei_information29%
933: TYPE := 'OCCUPATIONAL';
934: l_eei_information28 pay_element_type_extra_info.eei_information28%

Line 932: l_eei_information29 pay_element_type_extra_info.eei_information29%

928: l_eei_information18 pay_element_type_extra_info.eei_information18%
929: TYPE;
930: l_eei_information30 pay_element_type_extra_info.eei_information30%
931: TYPE :='UNPAID';
932: l_eei_information29 pay_element_type_extra_info.eei_information29%
933: TYPE := 'OCCUPATIONAL';
934: l_eei_information28 pay_element_type_extra_info.eei_information28%
935: TYPE := 'PQP_GAP_ENTITLEMENT_BANDS';
936: l_eei_information27 pay_element_type_extra_info.eei_information27%

Line 934: l_eei_information28 pay_element_type_extra_info.eei_information28%

930: l_eei_information30 pay_element_type_extra_info.eei_information30%
931: TYPE :='UNPAID';
932: l_eei_information29 pay_element_type_extra_info.eei_information29%
933: TYPE := 'OCCUPATIONAL';
934: l_eei_information28 pay_element_type_extra_info.eei_information28%
935: TYPE := 'PQP_GAP_ENTITLEMENT_BANDS';
936: l_eei_information27 pay_element_type_extra_info.eei_information27%
937: TYPE := 'PQP_GB_OSP_CALENDAR_RULES';
938:

Line 936: l_eei_information27 pay_element_type_extra_info.eei_information27%

932: l_eei_information29 pay_element_type_extra_info.eei_information29%
933: TYPE := 'OCCUPATIONAL';
934: l_eei_information28 pay_element_type_extra_info.eei_information28%
935: TYPE := 'PQP_GAP_ENTITLEMENT_BANDS';
936: l_eei_information27 pay_element_type_extra_info.eei_information27%
937: TYPE := 'PQP_GB_OSP_CALENDAR_RULES';
938:
939: l_ctr BINARY_INTEGER:=0;
940: l_idx BINARY_INTEGER:=0;

Line 961: FROM pay_element_type_extra_info

957: AND balance_name = c_bal_name;
958:
959: CURSOR csr_chk_primary_exists is
960: SELECT 'X'
961: FROM pay_element_type_extra_info
962: WHERE eei_information1 = fnd_number.number_to_canonical(p_plan_id)
963: AND eei_information16 = 'Y'
964: AND information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
965: AND rownum = 1;

Line 1583: FROM pay_element_type_extra_info pete

1579:
1580: CURSOR csr_get_lookup_type(c_base_name in varchar2)
1581: IS
1582: SELECT DISTINCT(pete.eei_information18) lookup_type
1583: FROM pay_element_type_extra_info pete
1584: ,pay_element_types_f petf
1585: -- ,pay_element_templates pet
1586: WHERE pete.element_type_id = petf.element_type_id
1587: AND pete.information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO'

Line 1968: l_daily_rate_uom pay_element_type_extra_info.eei_information13%TYPE ;

1964:
1965: -- Added For Hours
1966:
1967: l_entitlements_uom VARCHAR2(1) ;
1968: l_daily_rate_uom pay_element_type_extra_info.eei_information13%TYPE ;
1969: l_days_hours VARCHAR2(10) ;
1970: l_template_name pay_element_templates.template_name%TYPE ;
1971:
1972:

Line 1976: FROM pay_element_type_extra_info pee

1972:
1973: CURSOR csr_get_scheme_type(p_ele_type_id IN NUMBER) IS
1974: SELECT pee.eei_information8 entitlements_uom
1975: ,pee.eei_information11 daily_rate_uom
1976: FROM pay_element_type_extra_info pee
1977: WHERE element_type_id = p_ele_type_id
1978: AND information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO' ;
1979:
1980: -- Added For Hours

Line 1998: FROM pay_element_type_extra_info petei

1994: SELECT element_type_extra_info_id
1995: ,fnd_number.canonical_to_number(eei_information9) entitlement_udt
1996: ,fnd_number.canonical_to_number(eei_information10) calendar_udt
1997: ,eei_information18 lookup_type
1998: FROM pay_element_type_extra_info petei
1999: WHERE element_type_id = c_element_type_id ;
2000:
2001: CURSOR csr_chk_eei_for_entudt (c_udt_id number)
2002: IS

Line 2004: FROM pay_element_type_extra_info

2000:
2001: CURSOR csr_chk_eei_for_entudt (c_udt_id number)
2002: IS
2003: SELECT 'X'
2004: FROM pay_element_type_extra_info
2005: WHERE eei_information1 <> fnd_number.number_to_canonical(p_plan_id)
2006: AND eei_information9 = fnd_number.number_to_canonical(c_udt_id)
2007: AND information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
2008: AND rownum = 1;

Line 2013: FROM pay_element_type_extra_info

2009:
2010: CURSOR csr_chk_eei_for_caludt (c_udt_id number)
2011: IS
2012: SELECT 'X'
2013: FROM pay_element_type_extra_info
2014: WHERE eei_information1 <> fnd_number.number_to_canonical(p_plan_id)
2015: AND eei_information10 = fnd_number.number_to_canonical(c_udt_id)
2016: AND information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
2017: AND rownum = 1;

Line 2022: FROM pay_element_type_extra_info

2018:
2019: CURSOR csr_chk_eei_for_lkt (c_lookup_type varchar2)
2020: IS
2021: SELECT 'X'
2022: FROM pay_element_type_extra_info
2023: WHERE eei_information1 <> fnd_number.number_to_canonical(p_plan_id)
2024: AND eei_information18 = c_lookup_type
2025: AND information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
2026: AND rownum = 1;

Line 2036: ,pay_element_type_extra_info peei

2032: SELECT 'X'
2033: FROM pay_element_templates pets
2034: ,pay_shadow_element_types pset
2035: ,pay_template_core_objects ptco
2036: ,pay_element_type_extra_info peei
2037: WHERE pets.template_id <> c_te_usrstr_id
2038: -- For the given user structure
2039: AND pets.template_name = p_template_name -- 'PQP OSP'
2040: AND pets.template_type = 'U'