APPS.PQP_GB_PENSION_SCHEME_TEMPLATE dependencies on HR_ORGANIZATION_INFORMATION

Line 851: ,hr_organization_information hoi

847: CURSOR csr_chk_provider_exists
848: IS
849: SELECT 'X'
850: FROM hr_all_organization_units hou
851: ,hr_organization_information hoi
852: WHERE hou.organization_id = p_pension_provider_id
853: AND ( hou.business_group_id = p_business_group_id
854: OR hou.business_group_id IS NULL
855: )

Line 871: FROM hr_organization_information

867:
868: CURSOR csr_chk_pens_type_in_prov
869: IS
870: SELECT 'X'
871: FROM hr_organization_information
872: WHERE organization_id = p_pension_provider_id
873: AND org_information_context = 'PQP_GB_PENSION_TYPES_INFO'
874: AND org_information1 = p_pension_type_id;
875:

Line 904: FROM hr_organization_information

900: -- Cursor to get ECON number
901: CURSOR csr_get_econ
902: IS
903: SELECT org_information7
904: FROM hr_organization_information
905: WHERE organization_id = p_business_group_id
906: AND org_information_context = 'Tax Details References';
907:
908: -- BUG 4108320

Line 923: l_econ_number hr_organization_information.org_information7%TYPE;

919:
920: l_proc_name VARCHAR2 (80) := g_proc_name
921: || 'insert_validate';
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: --