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.PAY_NL_WAGE_REPORT_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 1776: FROM hr_organization_information

1772: ,org_information3
1773: ,fnd_number.canonical_to_number(org_information4) amount
1774: ,org_information5 frequency
1775: ,org_information6
1776: FROM hr_organization_information
1777: WHERE organization_id = c_org_id
1778: AND org_information_context = 'NL_ORG_FLAT_RATE_TAXATION'
1779: -- AND org_information3 = '1' -- Bug# 5754707
1780: AND org_information6 = c_payroll_type

Line 2466: FROM hr_organization_information hoi

2462: CURSOR csr_get_le_info (p_organization_id NUMBER) IS
2463: SELECT hoi.org_information2 org_id
2464: ,hoi.org_information5 Public_Org
2465: ,hoi.org_information6 Own_Risk_Cover
2466: FROM hr_organization_information hoi
2467: WHERE hoi.org_information_context = 'NL_LE_TAX_DETAILS'
2468: AND hoi.organization_id = p_organization_id
2469: AND EXISTS (SELECT 1
2470: FROM hr_organization_information hoi1

Line 2470: FROM hr_organization_information hoi1

2466: FROM hr_organization_information hoi
2467: WHERE hoi.org_information_context = 'NL_LE_TAX_DETAILS'
2468: AND hoi.organization_id = p_organization_id
2469: AND EXISTS (SELECT 1
2470: FROM hr_organization_information hoi1
2471: WHERE hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
2472: AND hoi1.org_information_context = 'CLASS'
2473: AND hoi1.organization_id = hoi.organization_id);
2474: /*SELECT hoi.org_information2 org_id

Line 2477: FROM hr_organization_information hoi

2473: AND hoi1.organization_id = hoi.organization_id);
2474: /*SELECT hoi.org_information2 org_id
2475: ,hoi.org_information5 Public_Org
2476: ,hoi.org_information6 Own_Risk_Cover
2477: FROM hr_organization_information hoi
2478: ,hr_organization_information hoi1
2479: WHERE hoi.org_information_context = 'NL_LE_TAX_DETAILS'
2480: AND hoi.organization_id = hoi1.organization_id
2481: AND hoi1.organization_id = p_organization_id

Line 2478: ,hr_organization_information hoi1

2474: /*SELECT hoi.org_information2 org_id
2475: ,hoi.org_information5 Public_Org
2476: ,hoi.org_information6 Own_Risk_Cover
2477: FROM hr_organization_information hoi
2478: ,hr_organization_information hoi1
2479: WHERE hoi.org_information_context = 'NL_LE_TAX_DETAILS'
2480: AND hoi.organization_id = hoi1.organization_id
2481: AND hoi1.organization_id = p_organization_id
2482: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 2490: ,hr_organization_information hoi

2486: ,c_business_group_id NUMBER) IS
2487: SELECT hoi.org_information5 Own_Risk_Cover
2488: ,hoi.org_information6 Contract_Code_Mapping
2489: FROM hr_organization_units hou
2490: ,hr_organization_information hoi
2491: WHERE hoi.org_information_context = 'NL_ORG_WR_INFO'
2492: AND hou.business_group_id = c_business_group_id
2493: AND hou.organization_id = hoi.organization_id
2494: AND hou.organization_id = c_employer_id;

Line 2499: FROM hr_organization_units hou,hr_organization_information hoi

2495: --
2496: CURSOR csr_public_org_flag(c_employer_id NUMBER
2497: ,c_business_group_id NUMBER) IS
2498: SELECT hoi.org_information17 Public_Org
2499: FROM hr_organization_units hou,hr_organization_information hoi
2500: WHERE hoi.org_information_context = 'NL_ORG_INFORMATION'
2501: AND hou.business_group_id = c_business_group_id
2502: AND hou.organization_id = hoi.organization_id
2503: AND hou.organization_id = c_employer_id;

Line 2507: from hr_organization_information

2503: AND hou.organization_id = c_employer_id;
2504: --
2505: CURSOR csr_retro_date(c_business_group_id NUMBER) IS
2506: select fnd_date.canonical_to_date(org_information5)
2507: from hr_organization_information
2508: where organization_id = c_business_group_id
2509: AND org_information_context = 'NL_BG_INFO';
2510: --
2511: l_start_date DATE;

Line 2607: FROM hr_organization_units hou,hr_organization_information hoi

2603: ,c_business_group_id NUMBER) IS
2604: SELECT hoi.org_information1 sender_id
2605: ,hoi.org_information2 contact_name
2606: ,hoi.org_information3 contact_num
2607: FROM hr_organization_units hou,hr_organization_information hoi
2608: WHERE hoi.org_information_context = 'NL_ORG_WR_INFO'
2609: AND hou.business_group_id = c_business_group_id
2610: AND hou.organization_id = hoi.organization_id
2611: AND hou.organization_id = c_employer_id;

Line 2619: ,hr_organization_information hoi

2615: ,c_business_group_id NUMBER) IS
2616: SELECT hoi.org_information14 tax_rep_name
2617: ,hoi.org_information4 tax_reg_num
2618: FROM hr_organization_units hou
2619: ,hr_organization_information hoi
2620: WHERE hoi.org_information_context = 'NL_ORG_INFORMATION'
2621: AND hou.business_group_id = c_business_group_id
2622: AND hou.organization_id = hoi.organization_id
2623: AND hou.organization_id = c_employer_id;

Line 2629: FROM hr_organization_information hoi

2625: CURSOR csr_le_hr_mapping_chk (p_organization_id NUMBER) IS
2626: SELECT hoi.org_information1 tax_ref_no
2627: ,hoi.org_information2 org_id
2628: ,hoi.org_information3 tax_rep_name
2629: FROM hr_organization_information hoi
2630: ,hr_organization_information hoi1
2631: WHERE hoi.org_information_context = 'NL_LE_TAX_DETAILS'
2632: AND hoi.organization_id = hoi1.organization_id
2633: AND hoi1.organization_id = p_organization_id

Line 2630: ,hr_organization_information hoi1

2626: SELECT hoi.org_information1 tax_ref_no
2627: ,hoi.org_information2 org_id
2628: ,hoi.org_information3 tax_rep_name
2629: FROM hr_organization_information hoi
2630: ,hr_organization_information hoi1
2631: WHERE hoi.org_information_context = 'NL_LE_TAX_DETAILS'
2632: AND hoi.organization_id = hoi1.organization_id
2633: AND hoi1.organization_id = p_organization_id
2634: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 2649: l_sip_sector hr_organization_information.org_information1%TYPE;

2645: l_con_mon_fd NUMBER;
2646: l_corr_bal NUMBER;
2647: --l_ret_cor_period csr_ret_cor_period%ROWTYPE;
2648: l_sector_flag VARCHAR2(1);
2649: l_sip_sector hr_organization_information.org_information1%TYPE;
2650: l_risk_grp hr_organization_information.org_information1%TYPE;
2651: l_c_base_mon_fd_z VARCHAR2(1);
2652: --
2653: --#

Line 2650: l_risk_grp hr_organization_information.org_information1%TYPE;

2646: l_corr_bal NUMBER;
2647: --l_ret_cor_period csr_ret_cor_period%ROWTYPE;
2648: l_sector_flag VARCHAR2(1);
2649: l_sip_sector hr_organization_information.org_information1%TYPE;
2650: l_risk_grp hr_organization_information.org_information1%TYPE;
2651: l_c_base_mon_fd_z VARCHAR2(1);
2652: --
2653: --#
2654: --

Line 2659: l_tax_ref_no hr_organization_information.org_information1%TYPE;

2655: empr_flag VARCHAR2(1);
2656: empe_flag VARCHAR2(1);
2657: l_exception_flag VARCHAR2(1);
2658: l_awf VARCHAR2(1);
2659: l_tax_ref_no hr_organization_information.org_information1%TYPE;
2660: l_tax_rep_name hr_organization_information.org_information3%TYPE;
2661: l_hr_tax_unit hr_all_organization_units.organization_id%TYPE;
2662: --#
2663: --

Line 2660: l_tax_rep_name hr_organization_information.org_information3%TYPE;

2656: empe_flag VARCHAR2(1);
2657: l_exception_flag VARCHAR2(1);
2658: l_awf VARCHAR2(1);
2659: l_tax_ref_no hr_organization_information.org_information1%TYPE;
2660: l_tax_rep_name hr_organization_information.org_information3%TYPE;
2661: l_hr_tax_unit hr_all_organization_units.organization_id%TYPE;
2662: --#
2663: --
2664: --

Line 2668: l_sector hr_organization_information.org_information1%TYPE;

2664: --
2665: --csr_employer_info_rec csr_employer_info%ROWTYPE;
2666: l_first_emp VARCHAR2(1);
2667: y NUMBER;
2668: l_sector hr_organization_information.org_information1%TYPE;
2669: l_risk_group hr_organization_information.org_information1%TYPE;
2670: p_swmf_col_bal_def_table BAL_COL_TABLE;
2671: l_val NUMBER;
2672: l_curr_ass_action_id NUMBER;

Line 2669: l_risk_group hr_organization_information.org_information1%TYPE;

2665: --csr_employer_info_rec csr_employer_info%ROWTYPE;
2666: l_first_emp VARCHAR2(1);
2667: y NUMBER;
2668: l_sector hr_organization_information.org_information1%TYPE;
2669: l_risk_group hr_organization_information.org_information1%TYPE;
2670: p_swmf_col_bal_def_table BAL_COL_TABLE;
2671: l_val NUMBER;
2672: l_curr_ass_action_id NUMBER;
2673: l_period_ass_action_id NUMBER;

Line 2768: FROM hr_organization_units hou,hr_organization_information hoi

2764: ,c_business_group_id NUMBER) IS
2765: SELECT hoi.org_information1 sender_id
2766: ,hoi.org_information2 contact_name
2767: ,hoi.org_information3 contact_num
2768: FROM hr_organization_units hou,hr_organization_information hoi
2769: WHERE hoi.org_information_context = 'NL_ORG_WR_INFO'
2770: AND hou.business_group_id = c_business_group_id
2771: AND hou.organization_id = hoi.organization_id
2772: AND hou.organization_id = c_employer_id;

Line 2780: ,hr_organization_information hoi

2776: ,c_business_group_id NUMBER) IS
2777: SELECT hoi.org_information14 tax_rep_name
2778: ,hoi.org_information4 tax_reg_num
2779: FROM hr_organization_units hou
2780: ,hr_organization_information hoi
2781: WHERE hoi.org_information_context = 'NL_ORG_INFORMATION'
2782: AND hou.business_group_id = c_business_group_id
2783: AND hou.organization_id = hoi.organization_id
2784: AND hou.organization_id = c_employer_id;

Line 2806: FROM hr_organization_information hoi1

2802: ,c_business_group_id NUMBER) IS
2803: SELECT distinct hoi1.org_information5 sector
2804: ,hoi1.org_information6 risk_group
2805: ,hoi1.organization_id
2806: FROM hr_organization_information hoi1
2807: ,hr_organization_information hoi2
2808: ,hr_organization_information hoi3
2809: ,per_org_structure_versions posv
2810: WHERE hoi2.org_information4 = hoi1.organization_id

Line 2807: ,hr_organization_information hoi2

2803: SELECT distinct hoi1.org_information5 sector
2804: ,hoi1.org_information6 risk_group
2805: ,hoi1.organization_id
2806: FROM hr_organization_information hoi1
2807: ,hr_organization_information hoi2
2808: ,hr_organization_information hoi3
2809: ,per_org_structure_versions posv
2810: WHERE hoi2.org_information4 = hoi1.organization_id
2811: AND hoi1.org_information5 IS NOT NULL

Line 2808: ,hr_organization_information hoi3

2804: ,hoi1.org_information6 risk_group
2805: ,hoi1.organization_id
2806: FROM hr_organization_information hoi1
2807: ,hr_organization_information hoi2
2808: ,hr_organization_information hoi3
2809: ,per_org_structure_versions posv
2810: WHERE hoi2.org_information4 = hoi1.organization_id
2811: AND hoi1.org_information5 IS NOT NULL
2812: AND hoi1.org_information6 IS NOT NULL

Line 2825: FROM hr_organization_information hoi4

2821: AND nvl(posv.date_to,to_date('31-12-4712','dd-mm-yyyy'))
2822: AND c_effective_date BETWEEN fnd_date.canonical_to_date(hoi2.org_information1)
2823: AND nvl(fnd_date.canonical_to_date(hoi2.org_information2),to_date('31-12-4712','dd-mm-yyyy'))
2824: AND EXISTS (SELECT 1
2825: FROM hr_organization_information hoi4
2826: WHERE hoi4.organization_id = hoi1.organization_id
2827: AND hoi4.org_information_context = 'NL_SIT'
2828: AND ORG_INFORMATION4 = 'WEWA')
2829: ORDER BY 1,2;

Line 2849: FROM hr_organization_information hoi

2845: /* CURSOR csr_le_hr_mapping_chk (p_organization_id NUMBER) IS
2846: SELECT hoi.org_information2 org_id
2847: ,hoi.org_information5 Public_Org
2848: ,hoi.org_information6 Own_Risk_Cover
2849: FROM hr_organization_information hoi
2850: WHERE hoi.org_information_context = 'NL_LE_TAX_DETAILS'
2851: AND hoi.organization_id = p_organization_id
2852: AND EXISTS (SELECT 1
2853: FROM hr_organization_information hoi1

Line 2853: FROM hr_organization_information hoi1

2849: FROM hr_organization_information hoi
2850: WHERE hoi.org_information_context = 'NL_LE_TAX_DETAILS'
2851: AND hoi.organization_id = p_organization_id
2852: AND EXISTS (SELECT 1
2853: FROM hr_organization_information hoi1
2854: WHERE hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
2855: AND hoi1.org_information_context = 'CLASS'
2856: AND hoi1.organization_id = hoi.organization_id); */
2857: CURSOR csr_le_hr_mapping_chk (p_organization_id NUMBER) IS

Line 2861: FROM hr_organization_information hoi

2857: CURSOR csr_le_hr_mapping_chk (p_organization_id NUMBER) IS
2858: SELECT hoi.org_information1 tax_ref_no
2859: ,hoi.org_information2 org_id
2860: ,hoi.org_information3 tax_rep_name
2861: FROM hr_organization_information hoi
2862: ,hr_organization_information hoi1
2863: WHERE hoi.org_information_context = 'NL_LE_TAX_DETAILS'
2864: AND hoi.organization_id = hoi1.organization_id
2865: AND hoi1.organization_id = p_organization_id

Line 2862: ,hr_organization_information hoi1

2858: SELECT hoi.org_information1 tax_ref_no
2859: ,hoi.org_information2 org_id
2860: ,hoi.org_information3 tax_rep_name
2861: FROM hr_organization_information hoi
2862: ,hr_organization_information hoi1
2863: WHERE hoi.org_information_context = 'NL_LE_TAX_DETAILS'
2864: AND hoi.organization_id = hoi1.organization_id
2865: AND hoi1.organization_id = p_organization_id
2866: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 2880: l_sip_sector hr_organization_information.org_information1%TYPE;

2876: l_con_mon_fd NUMBER;
2877: l_corr_bal NUMBER;
2878: l_ret_cor_period csr_ret_cor_period%ROWTYPE;
2879: l_sector_flag VARCHAR2(1);
2880: l_sip_sector hr_organization_information.org_information1%TYPE;
2881: l_risk_grp hr_organization_information.org_information1%TYPE;
2882: l_c_base_mon_fd_z VARCHAR2(1);
2883: --
2884: --#

Line 2881: l_risk_grp hr_organization_information.org_information1%TYPE;

2877: l_corr_bal NUMBER;
2878: l_ret_cor_period csr_ret_cor_period%ROWTYPE;
2879: l_sector_flag VARCHAR2(1);
2880: l_sip_sector hr_organization_information.org_information1%TYPE;
2881: l_risk_grp hr_organization_information.org_information1%TYPE;
2882: l_c_base_mon_fd_z VARCHAR2(1);
2883: --
2884: --#
2885: CURSOR csr_get_PA_exception_info(p_payroll_action_id IN NUMBER) IS

Line 2917: l_tax_ref_no hr_organization_information.org_information1%TYPE;

2913: empr_flag VARCHAR2(1);
2914: empe_flag VARCHAR2(1);
2915: l_exception_flag VARCHAR2(1);
2916: l_awf VARCHAR2(1);
2917: l_tax_ref_no hr_organization_information.org_information1%TYPE;
2918: l_tax_rep_name hr_organization_information.org_information3%TYPE;
2919: l_hr_tax_unit hr_all_organization_units.organization_id%TYPE;
2920: --#
2921: --

Line 2918: l_tax_rep_name hr_organization_information.org_information3%TYPE;

2914: empe_flag VARCHAR2(1);
2915: l_exception_flag VARCHAR2(1);
2916: l_awf VARCHAR2(1);
2917: l_tax_ref_no hr_organization_information.org_information1%TYPE;
2918: l_tax_rep_name hr_organization_information.org_information3%TYPE;
2919: l_hr_tax_unit hr_all_organization_units.organization_id%TYPE;
2920: --#
2921: --
2922: CURSOR csr_get_pactid IS

Line 3027: l_sector hr_organization_information.org_information1%TYPE;

3023: --
3024: csr_employer_info_rec csr_employer_info%ROWTYPE;
3025: l_first_emp VARCHAR2(1);
3026: y NUMBER;
3027: l_sector hr_organization_information.org_information1%TYPE;
3028: l_risk_group hr_organization_information.org_information1%TYPE;
3029: p_swmf_col_bal_def_table BAL_COL_TABLE;
3030: l_val NUMBER;
3031: l_curr_ass_action_id NUMBER;

Line 3028: l_risk_group hr_organization_information.org_information1%TYPE;

3024: csr_employer_info_rec csr_employer_info%ROWTYPE;
3025: l_first_emp VARCHAR2(1);
3026: y NUMBER;
3027: l_sector hr_organization_information.org_information1%TYPE;
3028: l_risk_group hr_organization_information.org_information1%TYPE;
3029: p_swmf_col_bal_def_table BAL_COL_TABLE;
3030: l_val NUMBER;
3031: l_curr_ass_action_id NUMBER;
3032: l_period_ass_action_id NUMBER;

Line 4355: FROM hr_organization_information hoi

4351: --
4352: CURSOR csr_le_hr_mapping_chk (p_organization_id NUMBER) IS
4353: SELECT hoi.org_information2 org_id
4354: ,hoi.org_information4 paid_flag
4355: FROM hr_organization_information hoi
4356: WHERE hoi.org_information_context = 'NL_LE_TAX_DETAILS'
4357: AND hoi.organization_id = p_organization_id
4358: AND EXISTS (SELECT 1
4359: FROM hr_organization_information hoi1

Line 4359: FROM hr_organization_information hoi1

4355: FROM hr_organization_information hoi
4356: WHERE hoi.org_information_context = 'NL_LE_TAX_DETAILS'
4357: AND hoi.organization_id = p_organization_id
4358: AND EXISTS (SELECT 1
4359: FROM hr_organization_information hoi1
4360: WHERE hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
4361: AND hoi1.org_information_context = 'CLASS'
4362: AND hoi1.organization_id = hoi.organization_id);
4363: --

Line 4367: FROM hr_organization_units hou,hr_organization_information hoi

4363: --
4364: CURSOR csr_get_empr_contact(c_employer_id NUMBER
4365: ,c_business_group_id NUMBER) IS
4366: SELECT hoi.org_information4 paid_flag
4367: FROM hr_organization_units hou,hr_organization_information hoi
4368: WHERE hoi.org_information_context = 'NL_ORG_WR_INFO'
4369: AND hou.business_group_id = c_business_group_id
4370: AND hou.organization_id = hoi.organization_id
4371: AND hou.organization_id = c_employer_id;

Line 4987: FROM hr_organization_information hoi

4983: ,hoi.org_information5 sector
4984: ,hoi.org_information6 risk_group
4985: ,fnd_date.canonical_to_date(aei.AEI_INFORMATION1) start_date
4986: ,fnd_date.canonical_to_date(aei.AEI_INFORMATION2) end_date
4987: FROM hr_organization_information hoi
4988: ,per_assignment_extra_info aei
4989: WHERE hoi.organization_id = nvl( aei.aei_information8,HR_NL_ORG_INFO.Get_SI_Provider_Info(aei.assignment_id,aei.AEI_INFORMATION3))
4990: AND aei.assignment_id = c_assignment_id
4991: AND aei.information_type = 'NL_SII'

Line 5000: FROM hr_organization_information

4996: ORDER BY 2,3;
4997: /*SELECT DISTINCT organization_id
4998: ,org_information5 sector
4999: ,org_information6 risk_group
5000: FROM hr_organization_information
5001: WHERE organization_id IN (SELECT HR_NL_ORG_INFO.Get_SI_Provider_Info(assignment_id,AEI_INFORMATION3)
5002: FROM per_assignment_extra_info
5003: WHERE assignment_id = c_assignment_id
5004: AND information_type = 'NL_SII'