APPS.PQP_GB_PENSION_SCHEME_TEMPLATE dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 881: FROM pay_element_type_extra_info eeit, pay_element_types_f pet

877:
878: CURSOR csr_chk_ocp_ele_info (c_element_type_id NUMBER)
879: IS
880: SELECT 'X'
881: FROM pay_element_type_extra_info eeit, pay_element_types_f pet
882: WHERE pet.element_type_id = c_element_type_id
883: AND ( ( pet.business_group_id IS NOT NULL
884: AND pet.business_group_id = p_business_group_id
885: )

Line 926: l_scon_number pay_element_type_extra_info.eei_information1%TYPE;

922: l_exists VARCHAR2 (1);
923: l_econ_number hr_organization_information.org_information7%TYPE;
924: l_scon_format VARCHAR2 (9) := 'A9999999A';
925: l_econ_format VARCHAR2 (9) := 'E9999999A';
926: l_scon_number pay_element_type_extra_info.eei_information1%TYPE;
927: --
928: BEGIN
929: --
930: hr_utility.set_location ( 'Entering: '

Line 1730: FROM pay_element_type_extra_info

1726: --
1727: CURSOR csr_get_scheme_prefix
1728: IS
1729: SELECT eei_information18
1730: FROM pay_element_type_extra_info
1731: WHERE element_type_id = p_element_type_id
1732: AND information_type = 'PQP_GB_PENSION_SCHEME_INFO';
1733:
1734: l_proc_name VARCHAR2 (80)

Line 1737: l_scheme_prefix pay_element_type_extra_info.eei_information18%TYPE;

1733:
1734: l_proc_name VARCHAR2 (80)
1735: := g_proc_name
1736: || 'get_scheme_prefix';
1737: l_scheme_prefix pay_element_type_extra_info.eei_information18%TYPE;
1738: --
1739: BEGIN
1740: --
1741: hr_utility.set_location ( 'Entering: '

Line 3405: FROM pay_element_type_extra_info

3401: -- Cursor to get pensionable salary balance information
3402: CURSOR csr_get_pens_bal_id (c_element_type_id NUMBER)
3403: IS
3404: SELECT fnd_number.canonical_to_number (eei_information17)
3405: FROM pay_element_type_extra_info
3406: WHERE element_type_id = c_element_type_id
3407: AND information_type = 'PQP_GB_PENSION_SCHEME_INFO';
3408:
3409: l_pensionable_sal_bal_id NUMBER;

Line 3424: FROM pay_element_type_extra_info eei

3420: IS
3421: SELECT 'X'
3422: FROM DUAL
3423: WHERE EXISTS ( SELECT 1
3424: FROM pay_element_type_extra_info eei
3425: ,pay_element_types_f pet
3426: WHERE pet.element_type_id = eei.element_type_id
3427: AND pet.business_group_id =
3428: p_business_group_id

Line 3923: FROM pay_element_type_extra_info petei

3919: -- element type id
3920: CURSOR csr_get_eei_info (c_element_type_id NUMBER)
3921: IS
3922: SELECT element_type_extra_info_id
3923: FROM pay_element_type_extra_info petei
3924: WHERE element_type_id = c_element_type_id;
3925:
3926: -- Cursor to check whether an sub classification row
3927: -- exists for the base element type id

Line 3953: FROM pay_element_type_extra_info

3949: -- Cursor to get pension category
3950: CURSOR csr_get_pens_cat
3951: IS
3952: SELECT eei_information4, eei_information6
3953: FROM pay_element_type_extra_info
3954: WHERE element_type_id = p_element_type_id
3955: AND information_type = 'PQP_GB_PENSION_SCHEME_INFO';
3956:
3957: -- Cursor to check whether this is an OCP scheme