APPS.PQP_NL_PGGM_PENSION_EXTRACTS dependencies on HR_ORGANIZATION_INFORMATION

Line 1951: hr_organization_information hoi

1947: -- If a valid version is not found then do nothing.
1948: CURSOR c_get_org_hierarchy IS
1949: SELECT pos.org_structure_version_id
1950: FROM per_org_structure_versions_v pos,
1951: hr_organization_information hoi
1952: WHERE hoi.organization_id = p_business_group_id
1953: AND To_Number(hoi.org_information1) = pos.organization_structure_id
1954: AND Trunc(p_effective_date) BETWEEN date_from
1955: AND Nvl(date_to,Hr_Api.g_eot)

Line 1998: FROM hr_organization_information

1994:
1995: --Cursor to check whether oganization is tax organization or not
1996: CURSOR csr_tax_org(c_org_id NUMBER) IS
1997: SELECT 'x'
1998: FROM hr_organization_information
1999: WHERE organization_id = c_org_id
2000: AND org_information_context = 'NL_ORG_INFORMATION'
2001: AND org_information3 IS NOT NULL
2002: AND org_information4 IS NOT NULL;

Line 2008: FROM hr_organization_information

2004: --Cursor to fetch the PGGM employer number from
2005: --org information context
2006: CURSOR csr_get_pggm_er_num(c_org_id IN Number) IS
2007: SELECT SUBSTR(NVL(org_information5,'000000'),1,6)
2008: FROM hr_organization_information
2009: WHERE org_information_context = 'PQP_NL_PGGM_INFO'
2010: AND organization_id = c_org_id;
2011:
2012: --Cursor to check the PTP in the Std Conditions tab

Line 3403: FROM hr_organization_information

3399: --Cursor to fetch the CAO Code from
3400: --org information context
3401: CURSOR csr_get_cao_code(c_org_id IN Number) IS
3402: SELECT SUBSTR(org_information6,1,6)
3403: FROM hr_organization_information
3404: WHERE org_information_context = 'PQP_NL_PGGM_INFO'
3405: AND organization_id = c_org_id
3406: AND g_extract_params(p_business_group_id).extract_end_date BETWEEN
3407: fnd_date.canonical_to_date (org_information1)

Line 3482: FROM hr_organization_information

3478: --Cursor to fetch the Emp Reg No. from
3479: --org information context
3480: CURSOR csr_emp_reg_num(c_org_id IN Number) IS
3481: SELECT lpad(org_information7,15,'0')
3482: FROM hr_organization_information
3483: WHERE organization_id = c_org_id
3484: AND org_information_context = 'PQP_NL_PGGM_INFO'
3485: AND g_extract_params(p_business_group_id).extract_end_date BETWEEN
3486: fnd_date.canonical_to_date (org_information1)