APPS.PQP_PENSION_PROVIDERS dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 872: from pay_element_type_extra_info eei

868: and ORG_INFORMATION1 = to_char(p_organization_id);
869:
870: Cursor c_is_pentype_attached_nl Is
871: Select 1
872: from pay_element_type_extra_info eei
873: where ((eei.information_type = 'PQP_NL_PRE_TAX_DEDUCTIONS'
874: and eei.eei_information_category = 'PQP_NL_PRE_TAX_DEDUCTIONS')
875: or (eei.information_type = 'PQP_NL_SAVINGS_DEDUCTIONS'
876: and eei.eei_information_category = 'PQP_NL_SAVINGS_DEDUCTIONS')

Line 884: from pay_element_type_extra_info eei

880: and eei.eei_information3 = p_organization_id;
881:
882: Cursor c_is_pentype_attached_gb Is
883: Select 1
884: from pay_element_type_extra_info eei
885: where eei.information_type = 'PQP_GB_PENSION_SCHEME_INFO'
886: and eei.eei_information_category = 'PQP_GB_PENSION_SCHEME_INFO'
887: and eei.eei_information3 = p_pension_type_id
888: and eei.eei_information2 = p_organization_id;

Line 892: from pay_element_type_extra_info eei

888: and eei.eei_information2 = p_organization_id;
889:
890: Cursor c_is_pentype_attached_hu Is
891: Select 1
892: from pay_element_type_extra_info eei
893: where eei.information_type = 'HU_PENSION_SCHEME_INFO'
894: and eei.eei_information_category = 'HU_PENSION_SCHEME_INFO'
895: and eei.eei_information3 = p_pension_type_id
896: and eei.eei_information2 = p_organization_id;

Line 900: from pay_element_type_extra_info eei

896: and eei.eei_information2 = p_organization_id;
897:
898: Cursor c_is_pentype_attached_ie Is
899: Select 1
900: from pay_element_type_extra_info eei
901: where eei.information_type = 'IE_PENSION_SCHEME_INFO'
902: and eei.eei_information_category = 'IE_PENSION_SCHEME_INFO'
903: and eei.eei_information1 = p_pension_type_id
904: and eei.eei_information2 = p_organization_id;

Line 1070: from pay_element_type_extra_info eei

1066: and organization_id = p_organization_id;
1067:
1068: Cursor csr_is_provider_attached Is
1069: Select 1
1070: from pay_element_type_extra_info eei
1071: where ((eei.information_type = 'PQP_NL_PRE_TAX_DEDUCTIONS'
1072: and eei.eei_information_category = 'PQP_NL_PRE_TAX_DEDUCTIONS')
1073: or (eei.information_type = 'PQP_NL_SAVINGS_DEDUCTIONS'
1074: and eei.eei_information_category = 'PQP_NL_SAVINGS_DEDUCTIONS')

Line 1226: from pay_element_type_extra_info eei

1222: and organization_id = p_organization_id;
1223:
1224: Cursor csr_is_provider_assigned Is
1225: Select 1
1226: from pay_element_type_extra_info eei
1227: where eei.information_type = 'PQP_GB_PENSION_SCHEME_INFO'
1228: and eei.eei_information_category = 'PQP_GB_PENSION_SCHEME_INFO'
1229: and eei.eei_information2 = p_organization_id;
1230:

Line 1472: from pay_element_type_extra_info eei

1468: and organization_id = p_organization_id;
1469:
1470: Cursor csr_is_provider_assigned Is
1471: Select 1
1472: from pay_element_type_extra_info eei
1473: where eei.information_type = 'HU_PENSION_SCHEME_INFO'
1474: and eei.eei_information_category = 'HU_PENSION_SCHEME_INFO'
1475: and eei.eei_information2 = p_organization_id;
1476:

Line 1717: from pay_element_type_extra_info eei

1713: and organization_id = p_organization_id;
1714:
1715: Cursor csr_is_provider_assigned Is
1716: Select 1
1717: from pay_element_type_extra_info eei
1718: where eei.information_type = 'IE_PENSION_SCHEME_INFO'
1719: and eei.eei_information_category = 'IE_PENSION_SCHEME_INFO'
1720: and eei.eei_information2 = p_organization_id;
1721: