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 2169: FROM hr_organization_information

2165: ,org_information3
2166: ,fnd_number.canonical_to_number(org_information4) amount
2167: ,org_information5 frequency
2168: ,org_information6
2169: FROM hr_organization_information
2170: WHERE organization_id = c_org_id
2171: AND org_information_context = 'NL_ORG_FLAT_RATE_TAXATION'
2172: -- AND org_information3 = '1' -- Bug# 5754707
2173: AND org_information6 = c_payroll_type

Line 2184: FROM hr_organization_information

2180: ,fnd_date.canonical_to_date (org_information2) end_date
2181: ,org_information3 tag_name
2182: ,fnd_number.canonical_to_number (org_information4) amount
2183: ,org_information5 frequency
2184: FROM hr_organization_information
2185: WHERE organization_id = c_org_id
2186: AND org_information_context = 'NL_ORG_WR_PREV_YR_CORRECTION'
2187: AND org_information6 = c_payroll_type
2188: AND c_balance_date BETWEEN fnd_date.canonical_to_date (org_information1)

Line 2325: FROM hr_organization_information

2321: CURSOR csr_get_org_lca_data(c_org_id NUMBER,
2322: c_date DATE) IS
2323: SELECT org_information2 method
2324: ,fnd_number.canonical_to_number (org_information3) amount
2325: FROM hr_organization_information
2326: WHERE organization_id = c_org_id
2327: AND org_information_context = 'NL_ORG_LCA_INFO'
2328: AND org_information1 = to_char(c_date,'YYYY');
2329: ----

Line 3635: FROM hr_organization_information hoi

3631: CURSOR csr_get_le_info (p_organization_id NUMBER) IS
3632: SELECT hoi.org_information2 org_id
3633: ,hoi.org_information5 Public_Org
3634: ,hoi.org_information6 Own_Risk_Cover
3635: FROM hr_organization_information hoi
3636: WHERE hoi.org_information_context = 'NL_LE_TAX_DETAILS'
3637: AND hoi.organization_id = p_organization_id
3638: AND EXISTS (SELECT 1
3639: FROM hr_organization_information hoi1

Line 3639: FROM hr_organization_information hoi1

3635: FROM hr_organization_information hoi
3636: WHERE hoi.org_information_context = 'NL_LE_TAX_DETAILS'
3637: AND hoi.organization_id = p_organization_id
3638: AND EXISTS (SELECT 1
3639: FROM hr_organization_information hoi1
3640: WHERE hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
3641: AND hoi1.org_information_context = 'CLASS'
3642: AND hoi1.organization_id = hoi.organization_id);
3643: /*SELECT hoi.org_information2 org_id

Line 3646: FROM hr_organization_information hoi

3642: AND hoi1.organization_id = hoi.organization_id);
3643: /*SELECT hoi.org_information2 org_id
3644: ,hoi.org_information5 Public_Org
3645: ,hoi.org_information6 Own_Risk_Cover
3646: FROM hr_organization_information hoi
3647: ,hr_organization_information hoi1
3648: WHERE hoi.org_information_context = 'NL_LE_TAX_DETAILS'
3649: AND hoi.organization_id = hoi1.organization_id
3650: AND hoi1.organization_id = p_organization_id

Line 3647: ,hr_organization_information hoi1

3643: /*SELECT hoi.org_information2 org_id
3644: ,hoi.org_information5 Public_Org
3645: ,hoi.org_information6 Own_Risk_Cover
3646: FROM hr_organization_information hoi
3647: ,hr_organization_information hoi1
3648: WHERE hoi.org_information_context = 'NL_LE_TAX_DETAILS'
3649: AND hoi.organization_id = hoi1.organization_id
3650: AND hoi1.organization_id = p_organization_id
3651: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 3659: ,hr_organization_information hoi

3655: ,c_business_group_id NUMBER) IS
3656: SELECT hoi.org_information5 Own_Risk_Cover
3657: ,hoi.org_information6 Contract_Code_Mapping
3658: FROM hr_organization_units hou
3659: ,hr_organization_information hoi
3660: WHERE hoi.org_information_context = 'NL_ORG_WR_INFO'
3661: AND hou.business_group_id = c_business_group_id
3662: AND hou.organization_id = hoi.organization_id
3663: AND hou.organization_id = c_employer_id;

Line 3668: FROM hr_organization_units hou,hr_organization_information hoi

3664: --
3665: CURSOR csr_public_org_flag(c_employer_id NUMBER
3666: ,c_business_group_id NUMBER) IS
3667: SELECT hoi.org_information17 Public_Org
3668: FROM hr_organization_units hou,hr_organization_information hoi
3669: WHERE hoi.org_information_context = 'NL_ORG_INFORMATION'
3670: AND hou.business_group_id = c_business_group_id
3671: AND hou.organization_id = hoi.organization_id
3672: AND hou.organization_id = c_employer_id;

Line 3676: from hr_organization_information

3672: AND hou.organization_id = c_employer_id;
3673: --
3674: CURSOR csr_retro_date(c_business_group_id NUMBER) IS
3675: select fnd_date.canonical_to_date(org_information5)
3676: from hr_organization_information
3677: where organization_id = c_business_group_id
3678: AND org_information_context = 'NL_BG_INFO';
3679: --
3680: l_start_date DATE;

Line 3783: FROM hr_organization_units hou,hr_organization_information hoi

3779: ,c_business_group_id NUMBER) IS
3780: SELECT hoi.org_information1 sender_id
3781: ,hoi.org_information2 contact_name
3782: ,hoi.org_information3 contact_num
3783: FROM hr_organization_units hou,hr_organization_information hoi
3784: WHERE hoi.org_information_context = 'NL_ORG_WR_INFO'
3785: AND hou.business_group_id = c_business_group_id
3786: AND hou.organization_id = hoi.organization_id
3787: AND hou.organization_id = c_employer_id;

Line 3795: ,hr_organization_information hoi

3791: ,c_business_group_id NUMBER) IS
3792: SELECT hoi.org_information14 tax_rep_name
3793: ,hoi.org_information4 tax_reg_num
3794: FROM hr_organization_units hou
3795: ,hr_organization_information hoi
3796: WHERE hoi.org_information_context = 'NL_ORG_INFORMATION'
3797: AND hou.business_group_id = c_business_group_id
3798: AND hou.organization_id = hoi.organization_id
3799: AND hou.organization_id = c_employer_id;

Line 3805: FROM hr_organization_information hoi

3801: CURSOR csr_le_hr_mapping_chk (p_organization_id NUMBER) IS
3802: SELECT hoi.org_information1 tax_ref_no
3803: ,hoi.org_information2 org_id
3804: ,hoi.org_information3 tax_rep_name
3805: FROM hr_organization_information hoi
3806: ,hr_organization_information hoi1
3807: WHERE hoi.org_information_context = 'NL_LE_TAX_DETAILS'
3808: AND hoi.organization_id = hoi1.organization_id
3809: AND hoi1.organization_id = p_organization_id

Line 3806: ,hr_organization_information hoi1

3802: SELECT hoi.org_information1 tax_ref_no
3803: ,hoi.org_information2 org_id
3804: ,hoi.org_information3 tax_rep_name
3805: FROM hr_organization_information hoi
3806: ,hr_organization_information hoi1
3807: WHERE hoi.org_information_context = 'NL_LE_TAX_DETAILS'
3808: AND hoi.organization_id = hoi1.organization_id
3809: AND hoi1.organization_id = p_organization_id
3810: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 3825: l_sip_sector hr_organization_information.org_information1%TYPE;

3821: l_con_mon_fd NUMBER;
3822: l_corr_bal NUMBER;
3823: --l_ret_cor_period csr_ret_cor_period%ROWTYPE;
3824: l_sector_flag VARCHAR2(1);
3825: l_sip_sector hr_organization_information.org_information1%TYPE;
3826: l_risk_grp hr_organization_information.org_information1%TYPE;
3827: l_c_base_mon_fd_z VARCHAR2(1);
3828: --
3829: --#

Line 3826: l_risk_grp hr_organization_information.org_information1%TYPE;

3822: l_corr_bal NUMBER;
3823: --l_ret_cor_period csr_ret_cor_period%ROWTYPE;
3824: l_sector_flag VARCHAR2(1);
3825: l_sip_sector hr_organization_information.org_information1%TYPE;
3826: l_risk_grp hr_organization_information.org_information1%TYPE;
3827: l_c_base_mon_fd_z VARCHAR2(1);
3828: --
3829: --#
3830: --

Line 3835: l_tax_ref_no hr_organization_information.org_information1%TYPE;

3831: empr_flag VARCHAR2(1);
3832: empe_flag VARCHAR2(1);
3833: l_exception_flag VARCHAR2(1);
3834: l_awf VARCHAR2(1);
3835: l_tax_ref_no hr_organization_information.org_information1%TYPE;
3836: l_tax_rep_name hr_organization_information.org_information3%TYPE;
3837: l_hr_tax_unit hr_all_organization_units.organization_id%TYPE;
3838: --#
3839: --

Line 3836: l_tax_rep_name hr_organization_information.org_information3%TYPE;

3832: empe_flag VARCHAR2(1);
3833: l_exception_flag VARCHAR2(1);
3834: l_awf VARCHAR2(1);
3835: l_tax_ref_no hr_organization_information.org_information1%TYPE;
3836: l_tax_rep_name hr_organization_information.org_information3%TYPE;
3837: l_hr_tax_unit hr_all_organization_units.organization_id%TYPE;
3838: --#
3839: --
3840: --

Line 3844: l_sector hr_organization_information.org_information1%TYPE;

3840: --
3841: --csr_employer_info_rec csr_employer_info%ROWTYPE;
3842: l_first_emp VARCHAR2(1);
3843: y NUMBER;
3844: l_sector hr_organization_information.org_information1%TYPE;
3845: l_risk_group hr_organization_information.org_information1%TYPE;
3846: p_swmf_col_bal_def_table BAL_COL_TABLE;
3847: l_val NUMBER;
3848: l_curr_ass_action_id NUMBER;

Line 3845: l_risk_group hr_organization_information.org_information1%TYPE;

3841: --csr_employer_info_rec csr_employer_info%ROWTYPE;
3842: l_first_emp VARCHAR2(1);
3843: y NUMBER;
3844: l_sector hr_organization_information.org_information1%TYPE;
3845: l_risk_group hr_organization_information.org_information1%TYPE;
3846: p_swmf_col_bal_def_table BAL_COL_TABLE;
3847: l_val NUMBER;
3848: l_curr_ass_action_id NUMBER;
3849: l_period_ass_action_id NUMBER;

Line 3981: FROM hr_organization_units hou,hr_organization_information hoi

3977: ,c_business_group_id NUMBER) IS
3978: SELECT hoi.org_information1 sender_id
3979: ,hoi.org_information2 contact_name
3980: ,hoi.org_information3 contact_num
3981: FROM hr_organization_units hou,hr_organization_information hoi
3982: WHERE hoi.org_information_context = 'NL_ORG_WR_INFO'
3983: AND hou.business_group_id = c_business_group_id
3984: AND hou.organization_id = hoi.organization_id
3985: AND hou.organization_id = c_employer_id;

Line 3993: ,hr_organization_information hoi

3989: ,c_business_group_id NUMBER) IS
3990: SELECT hoi.org_information14 tax_rep_name
3991: ,hoi.org_information4 tax_reg_num
3992: FROM hr_organization_units hou
3993: ,hr_organization_information hoi
3994: WHERE hoi.org_information_context = 'NL_ORG_INFORMATION'
3995: AND hou.business_group_id = c_business_group_id
3996: AND hou.organization_id = hoi.organization_id
3997: AND hou.organization_id = c_employer_id;

Line 4003: FROM hr_organization_information hoi

3999: CURSOR csr_le_hr_mapping_chk (p_organization_id NUMBER) IS
4000: SELECT hoi.org_information1 tax_ref_no
4001: ,hoi.org_information2 org_id
4002: ,hoi.org_information3 tax_rep_name
4003: FROM hr_organization_information hoi
4004: ,hr_organization_information hoi1
4005: WHERE hoi.org_information_context = 'NL_LE_TAX_DETAILS'
4006: AND hoi.organization_id = hoi1.organization_id
4007: AND hoi1.organization_id = p_organization_id

Line 4004: ,hr_organization_information hoi1

4000: SELECT hoi.org_information1 tax_ref_no
4001: ,hoi.org_information2 org_id
4002: ,hoi.org_information3 tax_rep_name
4003: FROM hr_organization_information hoi
4004: ,hr_organization_information hoi1
4005: WHERE hoi.org_information_context = 'NL_LE_TAX_DETAILS'
4006: AND hoi.organization_id = hoi1.organization_id
4007: AND hoi1.organization_id = p_organization_id
4008: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 4023: l_sip_sector hr_organization_information.org_information1%TYPE;

4019: l_con_mon_fd NUMBER;
4020: l_corr_bal NUMBER;
4021: --l_ret_cor_period csr_ret_cor_period%ROWTYPE;
4022: l_sector_flag VARCHAR2(1);
4023: l_sip_sector hr_organization_information.org_information1%TYPE;
4024: l_risk_grp hr_organization_information.org_information1%TYPE;
4025: l_c_base_mon_fd_z VARCHAR2(1);
4026: --
4027: --#

Line 4024: l_risk_grp hr_organization_information.org_information1%TYPE;

4020: l_corr_bal NUMBER;
4021: --l_ret_cor_period csr_ret_cor_period%ROWTYPE;
4022: l_sector_flag VARCHAR2(1);
4023: l_sip_sector hr_organization_information.org_information1%TYPE;
4024: l_risk_grp hr_organization_information.org_information1%TYPE;
4025: l_c_base_mon_fd_z VARCHAR2(1);
4026: --
4027: --#
4028: --

Line 4033: l_tax_ref_no hr_organization_information.org_information1%TYPE;

4029: empr_flag VARCHAR2(1);
4030: empe_flag VARCHAR2(1);
4031: l_exception_flag VARCHAR2(1);
4032: l_awf VARCHAR2(1);
4033: l_tax_ref_no hr_organization_information.org_information1%TYPE;
4034: l_tax_rep_name hr_organization_information.org_information3%TYPE;
4035: l_hr_tax_unit hr_all_organization_units.organization_id%TYPE;
4036: --#
4037: --

Line 4034: l_tax_rep_name hr_organization_information.org_information3%TYPE;

4030: empe_flag VARCHAR2(1);
4031: l_exception_flag VARCHAR2(1);
4032: l_awf VARCHAR2(1);
4033: l_tax_ref_no hr_organization_information.org_information1%TYPE;
4034: l_tax_rep_name hr_organization_information.org_information3%TYPE;
4035: l_hr_tax_unit hr_all_organization_units.organization_id%TYPE;
4036: --#
4037: --
4038: --

Line 4042: l_sector hr_organization_information.org_information1%TYPE;

4038: --
4039: --csr_employer_info_rec csr_employer_info%ROWTYPE;
4040: l_first_emp VARCHAR2(1);
4041: y NUMBER;
4042: l_sector hr_organization_information.org_information1%TYPE;
4043: l_risk_group hr_organization_information.org_information1%TYPE;
4044: p_swmf_col_bal_def_table BAL_COL_TABLE;
4045: l_val NUMBER;
4046: l_curr_ass_action_id NUMBER;

Line 4043: l_risk_group hr_organization_information.org_information1%TYPE;

4039: --csr_employer_info_rec csr_employer_info%ROWTYPE;
4040: l_first_emp VARCHAR2(1);
4041: y NUMBER;
4042: l_sector hr_organization_information.org_information1%TYPE;
4043: l_risk_group hr_organization_information.org_information1%TYPE;
4044: p_swmf_col_bal_def_table BAL_COL_TABLE;
4045: l_val NUMBER;
4046: l_curr_ass_action_id NUMBER;
4047: l_period_ass_action_id NUMBER;

Line 4286: FROM hr_organization_units hou,hr_organization_information hoi

4282: ,c_business_group_id NUMBER) IS
4283: SELECT hoi.org_information1 sender_id
4284: ,hoi.org_information2 contact_name
4285: ,hoi.org_information3 contact_num
4286: FROM hr_organization_units hou,hr_organization_information hoi
4287: WHERE hoi.org_information_context = 'NL_ORG_WR_INFO'
4288: AND hou.business_group_id = c_business_group_id
4289: AND hou.organization_id = hoi.organization_id
4290: AND hou.organization_id = c_employer_id;

Line 4298: ,hr_organization_information hoi

4294: ,c_business_group_id NUMBER) IS
4295: SELECT hoi.org_information14 tax_rep_name
4296: ,hoi.org_information4 tax_reg_num
4297: FROM hr_organization_units hou
4298: ,hr_organization_information hoi
4299: WHERE hoi.org_information_context = 'NL_ORG_INFORMATION'
4300: AND hou.business_group_id = c_business_group_id
4301: AND hou.organization_id = hoi.organization_id
4302: AND hou.organization_id = c_employer_id;

Line 4324: FROM hr_organization_information hoi1

4320: ,c_business_group_id NUMBER) IS
4321: SELECT distinct hoi1.org_information5 sector
4322: ,hoi1.org_information6 risk_group
4323: ,hoi1.organization_id
4324: FROM hr_organization_information hoi1
4325: ,hr_organization_information hoi2
4326: ,hr_organization_information hoi3
4327: ,per_org_structure_versions posv
4328: WHERE hoi2.org_information4 = hoi1.organization_id

Line 4325: ,hr_organization_information hoi2

4321: SELECT distinct hoi1.org_information5 sector
4322: ,hoi1.org_information6 risk_group
4323: ,hoi1.organization_id
4324: FROM hr_organization_information hoi1
4325: ,hr_organization_information hoi2
4326: ,hr_organization_information hoi3
4327: ,per_org_structure_versions posv
4328: WHERE hoi2.org_information4 = hoi1.organization_id
4329: AND hoi1.org_information5 IS NOT NULL

Line 4326: ,hr_organization_information hoi3

4322: ,hoi1.org_information6 risk_group
4323: ,hoi1.organization_id
4324: FROM hr_organization_information hoi1
4325: ,hr_organization_information hoi2
4326: ,hr_organization_information hoi3
4327: ,per_org_structure_versions posv
4328: WHERE hoi2.org_information4 = hoi1.organization_id
4329: AND hoi1.org_information5 IS NOT NULL
4330: AND hoi1.org_information6 IS NOT NULL

Line 4343: FROM hr_organization_information hoi4

4339: AND nvl(posv.date_to,to_date('31-12-4712','dd-mm-yyyy'))
4340: AND c_effective_date BETWEEN fnd_date.canonical_to_date(hoi2.org_information1)
4341: AND nvl(fnd_date.canonical_to_date(hoi2.org_information2),to_date('31-12-4712','dd-mm-yyyy'))
4342: AND EXISTS (SELECT 1
4343: FROM hr_organization_information hoi4
4344: WHERE hoi4.organization_id = hoi1.organization_id
4345: AND hoi4.org_information_context = 'NL_SIT'
4346: AND ORG_INFORMATION4 = 'WEWA')
4347: ORDER BY 1,2;

Line 4367: FROM hr_organization_information hoi

4363: /* CURSOR csr_le_hr_mapping_chk (p_organization_id NUMBER) IS
4364: SELECT hoi.org_information2 org_id
4365: ,hoi.org_information5 Public_Org
4366: ,hoi.org_information6 Own_Risk_Cover
4367: FROM hr_organization_information hoi
4368: WHERE hoi.org_information_context = 'NL_LE_TAX_DETAILS'
4369: AND hoi.organization_id = p_organization_id
4370: AND EXISTS (SELECT 1
4371: FROM hr_organization_information hoi1

Line 4371: FROM hr_organization_information hoi1

4367: FROM hr_organization_information hoi
4368: WHERE hoi.org_information_context = 'NL_LE_TAX_DETAILS'
4369: AND hoi.organization_id = p_organization_id
4370: AND EXISTS (SELECT 1
4371: FROM hr_organization_information hoi1
4372: WHERE hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
4373: AND hoi1.org_information_context = 'CLASS'
4374: AND hoi1.organization_id = hoi.organization_id); */
4375: CURSOR csr_le_hr_mapping_chk (p_organization_id NUMBER) IS

Line 4379: FROM hr_organization_information hoi

4375: CURSOR csr_le_hr_mapping_chk (p_organization_id NUMBER) IS
4376: SELECT hoi.org_information1 tax_ref_no
4377: ,hoi.org_information2 org_id
4378: ,hoi.org_information3 tax_rep_name
4379: FROM hr_organization_information hoi
4380: ,hr_organization_information hoi1
4381: WHERE hoi.org_information_context = 'NL_LE_TAX_DETAILS'
4382: AND hoi.organization_id = hoi1.organization_id
4383: AND hoi1.organization_id = p_organization_id

Line 4380: ,hr_organization_information hoi1

4376: SELECT hoi.org_information1 tax_ref_no
4377: ,hoi.org_information2 org_id
4378: ,hoi.org_information3 tax_rep_name
4379: FROM hr_organization_information hoi
4380: ,hr_organization_information hoi1
4381: WHERE hoi.org_information_context = 'NL_LE_TAX_DETAILS'
4382: AND hoi.organization_id = hoi1.organization_id
4383: AND hoi1.organization_id = p_organization_id
4384: AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'

Line 4398: l_sip_sector hr_organization_information.org_information1%TYPE;

4394: l_con_mon_fd NUMBER;
4395: l_corr_bal NUMBER;
4396: l_ret_cor_period csr_ret_cor_period%ROWTYPE;
4397: l_sector_flag VARCHAR2(1);
4398: l_sip_sector hr_organization_information.org_information1%TYPE;
4399: l_risk_grp hr_organization_information.org_information1%TYPE;
4400: l_c_base_mon_fd_z VARCHAR2(1);
4401: --
4402: --#

Line 4399: l_risk_grp hr_organization_information.org_information1%TYPE;

4395: l_corr_bal NUMBER;
4396: l_ret_cor_period csr_ret_cor_period%ROWTYPE;
4397: l_sector_flag VARCHAR2(1);
4398: l_sip_sector hr_organization_information.org_information1%TYPE;
4399: l_risk_grp hr_organization_information.org_information1%TYPE;
4400: l_c_base_mon_fd_z VARCHAR2(1);
4401: --
4402: --#
4403: CURSOR csr_get_PA_exception_info(p_payroll_action_id IN NUMBER) IS

Line 4435: l_tax_ref_no hr_organization_information.org_information1%TYPE;

4431: empr_flag VARCHAR2(1);
4432: empe_flag VARCHAR2(1);
4433: l_exception_flag VARCHAR2(1);
4434: l_awf VARCHAR2(1);
4435: l_tax_ref_no hr_organization_information.org_information1%TYPE;
4436: l_tax_rep_name hr_organization_information.org_information3%TYPE;
4437: l_hr_tax_unit hr_all_organization_units.organization_id%TYPE;
4438: --#
4439: --

Line 4436: l_tax_rep_name hr_organization_information.org_information3%TYPE;

4432: empe_flag VARCHAR2(1);
4433: l_exception_flag VARCHAR2(1);
4434: l_awf VARCHAR2(1);
4435: l_tax_ref_no hr_organization_information.org_information1%TYPE;
4436: l_tax_rep_name hr_organization_information.org_information3%TYPE;
4437: l_hr_tax_unit hr_all_organization_units.organization_id%TYPE;
4438: --#
4439: --
4440: CURSOR csr_get_pactid IS

Line 4545: l_sector hr_organization_information.org_information1%TYPE;

4541: --
4542: csr_employer_info_rec csr_employer_info%ROWTYPE;
4543: l_first_emp VARCHAR2(1);
4544: y NUMBER;
4545: l_sector hr_organization_information.org_information1%TYPE;
4546: l_risk_group hr_organization_information.org_information1%TYPE;
4547: p_swmf_col_bal_def_table BAL_COL_TABLE;
4548: l_val NUMBER;
4549: l_curr_ass_action_id NUMBER;

Line 4546: l_risk_group hr_organization_information.org_information1%TYPE;

4542: csr_employer_info_rec csr_employer_info%ROWTYPE;
4543: l_first_emp VARCHAR2(1);
4544: y NUMBER;
4545: l_sector hr_organization_information.org_information1%TYPE;
4546: l_risk_group hr_organization_information.org_information1%TYPE;
4547: p_swmf_col_bal_def_table BAL_COL_TABLE;
4548: l_val NUMBER;
4549: l_curr_ass_action_id NUMBER;
4550: l_period_ass_action_id NUMBER;

Line 4587: FROM hr_organization_information

4583: ,fnd_number.canonical_to_number(org_information4) amount
4584: ,org_information5 frequency
4585: ,org_information6 */
4586: --10100628
4587: FROM hr_organization_information
4588: WHERE organization_id = p_tax_unit_id
4589: AND org_information_context = 'NL_ORG_FLAT_RATE_TAXATION'
4590: AND org_information6 = c_payroll_type
4591: AND p_start_date BETWEEN fnd_date.canonical_to_date(org_information1)

Line 4621: FROM hr_organization_information

4617: AND
4618: EXISTS
4619: (
4620: SELECT 1
4621: FROM hr_organization_information
4622: WHERE organization_id = p_tax_unit_id
4623: AND org_information_context = 'NL_ORG_FLAT_RATE_TAXATION'
4624: AND org_information6 = c_payroll_type
4625: AND START_DATE BETWEEN fnd_date.canonical_to_date(org_information1)

Line 4645: FROM hr_organization_information

4641: AND
4642: EXISTS
4643: (
4644: SELECT 1
4645: FROM hr_organization_information
4646: WHERE organization_id = p_tax_unit_id
4647: AND (
4648: (
4649: org_information_context = 'NL_ORG_FLAT_RATE_TAXATION'

Line 7243: FROM hr_organization_information hoi

7239: --
7240: CURSOR csr_le_hr_mapping_chk (p_organization_id NUMBER) IS
7241: SELECT hoi.org_information2 org_id
7242: ,hoi.org_information4 paid_flag
7243: FROM hr_organization_information hoi
7244: WHERE hoi.org_information_context = 'NL_LE_TAX_DETAILS'
7245: AND hoi.organization_id = p_organization_id
7246: AND EXISTS (SELECT 1
7247: FROM hr_organization_information hoi1

Line 7247: FROM hr_organization_information hoi1

7243: FROM hr_organization_information hoi
7244: WHERE hoi.org_information_context = 'NL_LE_TAX_DETAILS'
7245: AND hoi.organization_id = p_organization_id
7246: AND EXISTS (SELECT 1
7247: FROM hr_organization_information hoi1
7248: WHERE hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
7249: AND hoi1.org_information_context = 'CLASS'
7250: AND hoi1.organization_id = hoi.organization_id);
7251: --

Line 7255: FROM hr_organization_units hou,hr_organization_information hoi

7251: --
7252: CURSOR csr_get_empr_contact(c_employer_id NUMBER
7253: ,c_business_group_id NUMBER) IS
7254: SELECT hoi.org_information4 paid_flag
7255: FROM hr_organization_units hou,hr_organization_information hoi
7256: WHERE hoi.org_information_context = 'NL_ORG_WR_INFO'
7257: AND hou.business_group_id = c_business_group_id
7258: AND hou.organization_id = hoi.organization_id
7259: AND hou.organization_id = c_employer_id;

Line 8140: FROM hr_organization_information hoi

8136: ,hoi.org_information5 sector
8137: ,hoi.org_information6 risk_group
8138: ,fnd_date.canonical_to_date(aei.AEI_INFORMATION1) start_date
8139: ,fnd_date.canonical_to_date(aei.AEI_INFORMATION2) end_date
8140: FROM hr_organization_information hoi
8141: ,per_assignment_extra_info aei
8142: WHERE hoi.organization_id = nvl( aei.aei_information8,HR_NL_ORG_INFO.Get_SI_Provider_Info(aei.assignment_id,aei.AEI_INFORMATION3))
8143: AND aei.assignment_id = c_assignment_id
8144: AND aei.information_type = 'NL_SII'

Line 8153: FROM hr_organization_information

8149: ORDER BY 2,3;
8150: /*SELECT DISTINCT organization_id
8151: ,org_information5 sector
8152: ,org_information6 risk_group
8153: FROM hr_organization_information
8154: WHERE organization_id IN (SELECT HR_NL_ORG_INFO.Get_SI_Provider_Info(assignment_id,AEI_INFORMATION3)
8155: FROM per_assignment_extra_info
8156: WHERE assignment_id = c_assignment_id
8157: AND information_type = 'NL_SII'