eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_NL_PENSION_EXTRACTS dependencies on HR_ORGANIZATION_INFORMATION

Line 2740: hr_organization_information hoi

2736: -- If a valid version is not found then do nothing.
2737: CURSOR c_get_org_hierarchy IS
2738: SELECT pos.org_structure_version_id
2739: FROM per_org_structure_versions_v pos,
2740: hr_organization_information hoi
2741: WHERE hoi.organization_id = p_business_group_id
2742: AND To_Number(hoi.org_information1) = pos.organization_structure_id
2743: AND Trunc(p_effective_date) BETWEEN date_from
2744: AND Nvl(date_to,Hr_Api.g_eot)

Line 2761: FROM hr_organization_information

2757:
2758: --Cursor to check whether oganization is tax organization or not
2759: CURSOR csr_tax_org(c_org_id NUMBER) IS
2760: SELECT 'x'
2761: FROM hr_organization_information
2762: WHERE organization_id = c_org_id
2763: AND org_information_context = 'NL_ORG_INFORMATION'
2764: AND org_information3 IS NOT NULL
2765: AND org_information4 IS NOT NULL;

Line 5721: hr_organization_information hoi

5717: -- If a valid version is not found then do nothing.
5718: CURSOR c_get_org_hierarchy IS
5719: SELECT pos.org_structure_version_id
5720: FROM per_org_structure_versions_v pos,
5721: hr_organization_information hoi
5722: WHERE hoi.organization_id = p_business_group_id
5723: AND To_Number(hoi.org_information1) = pos.organization_structure_id
5724: AND Trunc(p_effective_date) BETWEEN date_from
5725: AND Nvl(date_to,Hr_Api.g_eot)

Line 5743: FROM hr_organization_information

5739: -- Cursor to check whether oganization is tax organization or not
5740: --
5741: CURSOR csr_tax_org(c_org_id NUMBER) IS
5742: SELECT 'x'
5743: FROM hr_organization_information
5744: WHERE organization_id = c_org_id
5745: AND org_information_context = 'NL_ORG_INFORMATION'
5746: AND org_information3 IS NOT NULL
5747: AND org_information4 IS NOT NULL;

Line 6860: FROM hr_organization_information

6856: -- Cursor to find the named hierarchy associated with the BG
6857: --
6858: CURSOR c_find_named_hierarchy IS
6859: SELECT org_information1
6860: FROM hr_organization_information
6861: WHERE organization_id = p_business_group_id
6862: AND org_information_context = 'NL_BG_INFO';
6863:
6864: --

Line 6900: FROM hr_organization_information

6896: --
6897: CURSOR csr_get_er_num(c_org_id IN Number) IS
6898: SELECT UPPER(nvl(lpad(org_information4,7,'0'),'0000000')) old_num
6899: ,SUBSTR(NVL(org_information2,'-1'),0,7) new_num
6900: FROM hr_organization_information
6901: WHERE org_information_context = 'PQP_ABP_PROVIDER'
6902: AND organization_id = c_org_id;
6903:
6904: --

Line 6916: l_new_er_num hr_organization_information.org_information2%TYPE := '-1';

6912: AND p_effective_date BETWEEN effective_start_date and effective_end_date --9583106
6913: ORDER BY effective_end_date DESC;
6914:
6915: l_old_er_num ben_ext_chg_evt_log.old_val1%TYPE := '-1';
6916: l_new_er_num hr_organization_information.org_information2%TYPE := '-1';
6917: l_org_info_id hr_organization_information.org_information_id%TYPE;
6918: l_version_id per_org_structure_versions_v.org_structure_version_id%TYPE DEFAULT NULL;
6919: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_ABP_ER_Num';
6920: l_ret_val NUMBER := -1;

Line 6917: l_org_info_id hr_organization_information.org_information_id%TYPE;

6913: ORDER BY effective_end_date DESC;
6914:
6915: l_old_er_num ben_ext_chg_evt_log.old_val1%TYPE := '-1';
6916: l_new_er_num hr_organization_information.org_information2%TYPE := '-1';
6917: l_org_info_id hr_organization_information.org_information_id%TYPE;
6918: l_version_id per_org_structure_versions_v.org_structure_version_id%TYPE DEFAULT NULL;
6919: l_proc_name VARCHAR2(150) := g_proc_name ||'Get_ABP_ER_Num';
6920: l_ret_val NUMBER := -1;
6921: l_org_id NUMBER;

Line 9352: FROM hr_organization_information

9348:
9349: --Cursor to find the named hierarchy associated with the BG
9350: CURSOR c_find_named_hierarchy IS
9351: SELECT org_information1
9352: FROM hr_organization_information
9353: WHERE organization_id = p_business_group_id
9354: AND org_information_context = 'NL_BG_INFO';
9355:
9356: --Cursor to find the valid version id for the particular named hierarchy

Line 9646: l_org_info_id hr_organization_information.org_information_id%TYPE;

9642: ) RETURN Number IS
9643:
9644: l_org_id hr_all_organization_units.organization_id%TYPE;
9645: l_ret_value Number := 0; --return
9646: l_org_info_id hr_organization_information.org_information_id%TYPE;
9647: l_named_hierarchy Number;
9648: l_version_id per_org_structure_versions_v.org_structure_version_id%TYPE DEFAULT NULL;
9649: l_loop_again Number;
9650: l_is_org_info_valid Varchar2(1);

Line 9663: FROM hr_organization_information

9659:
9660: --Cursor to find the named hierarchy associated with the BG
9661: CURSOR c_find_named_hierarchy IS
9662: SELECT org_information1
9663: FROM hr_organization_information
9664: WHERE organization_id = p_business_group_id
9665: AND org_information_context = 'NL_BG_INFO';
9666:
9667: --Cursor to find the valid version id for the particular named hierarchy

Line 9696: FROM hr_organization_information hoi

9692: --Cursor to find if there is any information record at the org level
9693: --if so return the org info id
9694: CURSOR c_get_valid_org_info(c_org_id IN hr_all_organization_units.organization_id%TYPE) IS
9695: SELECT hoi.org_information_id
9696: FROM hr_organization_information hoi
9697: WHERE hoi.org_information_context = 'PQP_NL_ABP_PT'
9698: AND hoi.org_information3 = To_Char(p_pension_type_id)
9699: AND NVL(hoi.org_information7,'Y') = 'Y'
9700: AND hoi.organization_id = c_org_id;

Line 9703: CURSOR c_get_org_info(c_org_id IN hr_organization_information.organization_id%TYPE) IS

9699: AND NVL(hoi.org_information7,'Y') = 'Y'
9700: AND hoi.organization_id = c_org_id;
9701:
9702: --Cursor to find the participation end date from org level information
9703: CURSOR c_get_org_info(c_org_id IN hr_organization_information.organization_id%TYPE) IS
9704: SELECT Fnd_Date.canonical_to_date(Nvl(hoi.org_information2,Fnd_Date.date_to_canonical(Hr_Api.g_eot)))
9705: FROM hr_organization_information hoi
9706: WHERE hoi.org_information_context = 'PQP_NL_ABP_PT'
9707: AND hoi.org_information3 = To_Char(p_pension_type_id)

Line 9705: FROM hr_organization_information hoi

9701:
9702: --Cursor to find the participation end date from org level information
9703: CURSOR c_get_org_info(c_org_id IN hr_organization_information.organization_id%TYPE) IS
9704: SELECT Fnd_Date.canonical_to_date(Nvl(hoi.org_information2,Fnd_Date.date_to_canonical(Hr_Api.g_eot)))
9705: FROM hr_organization_information hoi
9706: WHERE hoi.org_information_context = 'PQP_NL_ABP_PT'
9707: AND hoi.org_information3 = To_Char(p_pension_type_id)
9708: AND hoi.org_information6 = 'Y'
9709: AND NVL(hoi.org_information7,'Y') = 'Y'

Line 9878: FROM hr_organization_information

9874:
9875: --Cursor to find the named hierarchy associated with the BG
9876: CURSOR c_find_named_hierarchy IS
9877: SELECT org_information1
9878: FROM hr_organization_information
9879: WHERE organization_id = p_business_group_id
9880: AND org_information_context = 'NL_BG_INFO';
9881:
9882: --Cursor to find the valid version id for the particular named hierarchy

Line 10290: hr_organization_information hoi,

10286:
10287: CURSOR c_rr_cur IS
10288: SELECT 1
10289: FROM per_all_assignments_f paf,
10290: hr_organization_information hoi,
10291: pqp_pension_types_f pty,
10292: pay_all_payrolls_f ppf
10293: WHERE paf.assignment_id = p_assignment_id
10294: AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date

Line 10302: FROM hr_organization_information hoi1

10298: AND (paf.organization_id = hoi.organization_id
10299: OR
10300: (fnd_number.canonical_to_number(ppf.prl_information1) = hoi.organization_id
10301: AND NOT EXISTS (SELECT 1
10302: FROM hr_organization_information hoi1
10303: WHERE hoi1.org_information_context = 'PQP_NL_ABP_PT'
10304: AND hoi1.org_information3 = TO_CHAR(pty.pension_type_id)
10305: AND hoi1.organization_id = paf.organization_id
10306: AND ( NVL(hoi1.org_information6,'N')= 'N'

Line 10442: hr_organization_information hoi,

10438: ,'FPU_R','A'
10439: ,'FPU_S','S'
10440: ,'FPU_T' ,'B') fpu_code
10441: FROM per_all_assignments_f paf,
10442: hr_organization_information hoi,
10443: pqp_pension_types_f pty,
10444: pay_all_payrolls_f ppf
10445: WHERE paf.assignment_id = p_assignment_id
10446: AND p_effective_date BETWEEN paf.effective_start_date AND paf.effective_end_date

Line 10454: FROM hr_organization_information hoi1

10450: AND (paf.organization_id = hoi.organization_id
10451: OR
10452: (fnd_number.canonical_to_number(ppf.prl_information1) = hoi.organization_id
10453: AND NOT EXISTS (SELECT 1
10454: FROM hr_organization_information hoi1
10455: WHERE hoi1.org_information_context = 'PQP_NL_ABP_PT'
10456: AND hoi1.org_information3 = TO_CHAR(pty.pension_type_id)
10457: AND hoi1.organization_id = paf.organization_id
10458: AND ( NVL(hoi1.org_information6,'N')= 'N'

Line 12268: FROM hr_organization_information

12264:
12265: --Cursor to find the named hierarchy associated with the BG
12266: CURSOR c_find_named_hierarchy IS
12267: SELECT org_information1
12268: FROM hr_organization_information
12269: WHERE organization_id = p_business_group_id
12270: AND org_information_context = 'NL_BG_INFO';
12271:
12272: --Cursor to find the valid version id for the particular named hierarchy

Line 16472: FROM hr_organization_information

16468: --
16469: CURSOR csr_get_new_er_num(c_org_id IN NUMBER
16470: ,c_effective_date IN DATE) IS
16471: SELECT SUBSTR(NVL(org_information2,'-1'),0,7)
16472: FROM hr_organization_information
16473: WHERE org_information_context = 'PQP_ABP_PROVIDER'
16474: AND organization_id = c_org_id;
16475:
16476: l_proc_name VARCHAR2(150) := g_proc_name ||'.Get_Header_EMR_Number';

Line 16508: FROM hr_organization_information

16504:
16505:
16506: CURSOR csr_get_submit_code IS
16507: SELECT Substr(org_information3,0,4)
16508: FROM hr_organization_information
16509: WHERE org_information_context = 'PQP_ABP_PROVIDER'
16510: AND organization_id = p_org_id;
16511:
16512: l_proc_name Varchar2(150) := g_proc_name ||'.Get_Header_Submit_Code';