APPS.PQP_GB_PENSION_SCHEME_TEMPLATE dependencies on HR_ORGANIZATION_INFORMATION

Line 847: ,hr_organization_information hoi

843: CURSOR csr_chk_provider_exists
844: IS
845: SELECT 'X'
846: FROM hr_all_organization_units hou
847: ,hr_organization_information hoi
848: WHERE hou.organization_id = p_pension_provider_id
849: AND ( hou.business_group_id = p_business_group_id
850: OR hou.business_group_id IS NULL
851: )

Line 867: FROM hr_organization_information

863:
864: CURSOR csr_chk_pens_type_in_prov
865: IS
866: SELECT 'X'
867: FROM hr_organization_information
868: WHERE organization_id = p_pension_provider_id
869: AND org_information_context = 'PQP_GB_PENSION_TYPES_INFO'
870: AND org_information1 = p_pension_type_id;
871:

Line 900: FROM hr_organization_information

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

Line 919: l_econ_number hr_organization_information.org_information7%TYPE;

915:
916: l_proc_name VARCHAR2 (80) := g_proc_name
917: || 'insert_validate';
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: --