APPS.PQP_GB_PENSION_SCHEME_TEMPLATE dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 877: FROM pay_element_type_extra_info eeit, pay_element_types_f pet

873:
874: CURSOR csr_chk_ocp_ele_info (c_element_type_id NUMBER)
875: IS
876: SELECT 'X'
877: FROM pay_element_type_extra_info eeit, pay_element_types_f pet
878: WHERE pet.element_type_id = c_element_type_id
879: AND ( ( pet.business_group_id IS NOT NULL
880: AND pet.business_group_id = p_business_group_id
881: )

Line 922: l_scon_number pay_element_type_extra_info.eei_information1%TYPE;

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

Line 1728: FROM pay_element_type_extra_info

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

Line 1735: l_scheme_prefix pay_element_type_extra_info.eei_information18%TYPE;

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

Line 3403: FROM pay_element_type_extra_info

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

Line 3422: FROM pay_element_type_extra_info eei

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

Line 3920: FROM pay_element_type_extra_info petei

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

Line 3950: FROM pay_element_type_extra_info

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