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_US_SQWL_ARCHIVE dependencies on HR_ORGANIZATION_INFORMATION

Line 72: 01-Feb-2006 sudedas 115.59 4890376 Removing hr_organization_information

68: for improving performance
69: 14-Mar-2007 saurgupt 115.62 5152728 Changed the range_cursor and action_creation to
70: improve perf. In range_cursor, removed pay_payrolls_f.
71: 07-Apr-2006 sudedas 115.60 4344959 changing preprocess_check, cursor (c_chk_asg_wp)
72: 01-Feb-2006 sudedas 115.59 4890376 Removing hr_organization_information
73: from action_creation cursors (including
74: LA,CT) as the checks are there for range_cursor
75: 24-JAN-2006 sackumar 115.58 4869678 Modified the c_get_latest_asg cursor in
76: archive_data procedure.removed the +0 from

Line 1068: hr_organization_information HOI_PR

1064: ppa.effective_date effective_end_date
1065: FROM per_all_assignments_f ASG,
1066: pay_assignment_actions paa,
1067: pay_payroll_actions ppa,
1068: hr_organization_information HOI_PR
1069: WHERE ppa.effective_date between l_period_start and l_period_end
1070: AND ppa.action_type in ('R', 'Q', 'V', 'B', 'I')
1071: AND paa.payroll_action_id = ppa.payroll_action_id
1072: AND hoi_pr.organization_id = paa.tax_unit_id

Line 1096: from hr_organization_information HOI

1092: and puar.tax_unit_id = hoi_pr.organization_id
1093: and SR.state_code = l_state)
1094: /* there shouldn't be any dependency on state tax rules
1095: AND EXISTS (select 'x'
1096: from hr_organization_information HOI
1097: where hoi.organization_id = hoi_pr.organization_id
1098: AND HOI.org_information_context = 'State Tax Rules'
1099: AND HOI.org_information1 = l_state
1100: AND NVL(HOI.org_information16, 'No') = 'No'

Line 1115: hr_organization_information HOI_PR,

1111: ppa.effective_date effective_end_date
1112: FROM per_all_assignments_f ASG,
1113: pay_assignment_actions paa,
1114: pay_payroll_actions ppa,
1115: hr_organization_information HOI_PR,
1116: pay_population_ranges ppr
1117: WHERE ppa.effective_date between l_period_start and l_period_end
1118: AND ppa.action_type in ('R', 'Q', 'V', 'B', 'I')
1119: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1147: from hr_organization_information HOI

1143: and puar.tax_unit_id = hoi_pr.organization_id
1144: and SR.state_code = l_state)
1145: /* there shouldn't be any dependency on state tax rules
1146: AND EXISTS (select 'x'
1147: from hr_organization_information HOI
1148: where hoi.organization_id = hoi_pr.organization_id
1149: AND HOI.org_information_context = 'State Tax Rules'
1150: AND HOI.org_information1 = l_state
1151: AND NVL(HOI.org_information16, 'No') = 'No'

Line 1159: FROM hr_organization_information

1155: /* California Multi Wage Plan Requirement */
1156:
1157: CURSOR c_chk_gre_wp (p_tax_unit_id number) IS
1158: SELECT count(*) ct
1159: FROM hr_organization_information
1160: WHERE organization_id = p_tax_unit_id
1161: AND org_information_context = 'PAY_US_STATE_WAGE_PLAN_INFO'
1162: AND org_information1 = 'CA'
1163: AND org_information4 = 'Y';

Line 1415: from hr_organization_information

1411: then
1412: begin
1413: select 'Y'
1414: into l_1099R_ind
1415: from hr_organization_information
1416: where organization_id = l_tax_unit_id
1417: and org_information_context = '1099R Magnetic Report Rules';
1418: exception
1419: when no_data_found then

Line 2131: FROM hr_organization_information hoi

2127:
2128:
2129: CURSOR c_gre_wage_plan_code IS
2130: SELECT hoi.org_information3 wage_plan
2131: FROM hr_organization_information hoi
2132: WHERE hoi.org_information_context = 'PAY_US_STATE_WAGE_PLAN_INFO'
2133: AND hoi.organization_id = taxunitid
2134: AND hoi.org_information1 = g_sqwl_state
2135: AND hoi.org_information4 = 'Y';

Line 3397: FROM hr_organization_information orgi,

3393: AND paei.information_type = 'PAY_US_ASG_STATE_WAGE_PLAN_CD'
3394: AND paei.aei_information1 = l_state /* Added for performance improvement Bug# 4344959 */
3395: AND paei.assignment_id = paf.assignment_id
3396: AND NOT EXISTS (SELECT null
3397: FROM hr_organization_information orgi,
3398: hr_soft_coding_keyflex sft
3399: WHERE orgi.organization_id = to_number(sft.segment1)
3400: AND sft.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
3401: AND orgi.org_information1 = paei.aei_information1

Line 3414: FROM hr_organization_information orgi

3410: SELECT count(*) ct
3411: FROM hr_legal_entities org
3412: WHERE org.business_group_id = l_bus_group_id
3413: AND EXISTS (SELECT null
3414: FROM hr_organization_information orgi
3415: WHERE organization_id = org.organization_id
3416: AND org_information_context = 'PAY_US_STATE_WAGE_PLAN_INFO'
3417: AND org_information1 = 'CA')
3418: AND NOT EXISTS ( SELECT null

Line 3419: FROM hr_organization_information orgi

3415: WHERE organization_id = org.organization_id
3416: AND org_information_context = 'PAY_US_STATE_WAGE_PLAN_INFO'
3417: AND org_information1 = 'CA')
3418: AND NOT EXISTS ( SELECT null
3419: FROM hr_organization_information orgi
3420: WHERE organization_id = org.organization_id
3421: AND org_information_context = 'PAY_US_STATE_WAGE_PLAN_INFO'
3422: AND org_information1 = 'CA'
3423: AND org_information4 = 'Y');

Line 3432: FROM hr_organization_information a

3428: (select distinct
3429: a.organization_id,
3430: a.org_information1,
3431: a.org_information3
3432: FROM hr_organization_information a
3433: WHERE org_information_context = 'PAY_US_STATE_WAGE_PLAN_INFO') b
3434: WHERE org.business_group_id = l_bus_group_id
3435: AND b.organization_id = org.organization_id
3436: AND 1 < ( SELECT count(*)

Line 3437: FROM hr_organization_information orgi

3433: WHERE org_information_context = 'PAY_US_STATE_WAGE_PLAN_INFO') b
3434: WHERE org.business_group_id = l_bus_group_id
3435: AND b.organization_id = org.organization_id
3436: AND 1 < ( SELECT count(*)
3437: FROM hr_organization_information orgi
3438: WHERE organization_id = org.organization_id
3439: AND org_information_context = 'PAY_US_STATE_WAGE_PLAN_INFO'
3440: AND org_information1 = b.org_information1
3441: AND org_information3 = b.org_information3);

Line 3445: l_wage_plan_code hr_organization_information.org_information3%TYPE;

3441: AND org_information3 = b.org_information3);
3442:
3443:
3444: l_flag VARCHAR2(4) ;
3445: l_wage_plan_code hr_organization_information.org_information3%TYPE;
3446: l_company_sui_id hr_organization_information.org_information2%TYPE;
3447: l_counter NUMBER := 0 ;
3448: l_distinct_wage_plan_code NUMBER := 0 ;
3449:

Line 3446: l_company_sui_id hr_organization_information.org_information2%TYPE;

3442:
3443:
3444: l_flag VARCHAR2(4) ;
3445: l_wage_plan_code hr_organization_information.org_information3%TYPE;
3446: l_company_sui_id hr_organization_information.org_information2%TYPE;
3447: l_counter NUMBER := 0 ;
3448: l_distinct_wage_plan_code NUMBER := 0 ;
3449:
3450:

Line 3775: select '1' from hr_organization_information

3771: l_preprocess_flag BOOLEAN := FALSE;
3772: l_parent_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
3773:
3774: cursor c_reporting_rules(cp_tax_unit_id in number) is
3775: select '1' from hr_organization_information
3776: where organization_id = cp_tax_unit_id
3777: and org_information_context = 'W2 Reporting Rules';
3778: begin
3779:

Line 3831: FROM hr_organization_information HOI,

3827: /* End of Bug 1220213 */
3828:
3829: if (l_state = 'LA' and l_report_cat = 'RTLAQ') then
3830: sqwl_range := 'SELECT distinct ASG.person_id
3831: FROM hr_organization_information HOI,
3832: per_assignments_f ASG,
3833: pay_us_asg_reporting puar,
3834: pay_state_rules SR
3835: WHERE SR.state_code = ''' || l_state || '''

Line 3848: from hr_organization_information HOI2

3844: AND HOI.ORG_INFORMATION_CONTEXT = ''State Tax Rules''
3845: AND HOI.ORG_INFORMATION1 = ''' || l_state || '''
3846: AND NVL(HOI.ORG_INFORMATION16,''No'') = ''Yes''
3847: AND not exists (select ''x''
3848: from hr_organization_information HOI2
3849: where HOI2.organization_id = puar.tax_unit_id
3850: AND HOI2.ORG_INFORMATION_CONTEXT = ''1099R Magnetic Report Rules''
3851: AND HOI2.ORG_INFORMATION2 is not null)
3852: AND ASG.payroll_id is not null

Line 3858: FROM hr_organization_information HOI,

3854: ORDER BY ASG.person_id';
3855:
3856: elsif (l_state = 'CT' and l_report_cat = 'RTCTN') then
3857: sqwl_range := 'SELECT distinct ASG.person_id
3858: FROM hr_organization_information HOI,
3859: per_assignments_f ASG,
3860: pay_us_asg_reporting puar,
3861: pay_state_rules SR
3862: WHERE SR.state_code = ''' || l_state || '''

Line 3875: from hr_organization_information HOI2

3871: AND HOI.ORG_INFORMATION_CONTEXT = ''State Tax Rules''
3872: AND HOI.ORG_INFORMATION1 = ''' || l_state || '''
3873: AND NVL(HOI.ORG_INFORMATION20,''No'') = ''Yes''
3874: AND not exists (select ''x''
3875: from hr_organization_information HOI2
3876: where HOI2.organization_id = puar.tax_unit_id
3877: AND HOI2.ORG_INFORMATION_CONTEXT = ''1099R Magnetic Report Rules''
3878: AND HOI2.ORG_INFORMATION2 is not null)
3879: AND ASG.payroll_id is not null

Line 3894: FROM hr_organization_information HOI,

3890: END IF;
3891: IF ((l_preprocess_flag = TRUE AND l_state = 'CA') OR
3892: l_state <> 'CA') THEN
3893: sqwl_range := 'SELECT distinct ASG.person_id
3894: FROM hr_organization_information HOI,
3895: per_assignments_f ASG,
3896: pay_us_asg_reporting puar,
3897: pay_state_rules SR
3898: WHERE SR.state_code = ''' || l_state || '''

Line 3907: from hr_organization_information HOI2

3903: AND ASG.effective_end_date >= ''' || l_start_date || '''
3904: AND ASG.business_group_id + 0 = ''' || l_business_group_id || '''
3905: AND ((''' || l_state || ''' IN ( ''CA'',''ME''))
3906: OR (not exists (select ''x''
3907: from hr_organization_information HOI2
3908: where HOI2.organization_id = puar.tax_unit_id
3909: AND HOI2.ORG_INFORMATION_CONTEXT = ''1099R Magnetic Report Rules''
3910: AND HOI2.ORG_INFORMATION2 is not null)))
3911: AND HOI.organization_id = puar.tax_unit_id

Line 3924: hr_organization_information HOI,

3920:
3921: /* commented by saurgupt for testing
3922: sqwl_range := 'SELECT distinct ASG.person_id
3923: FROM pay_payrolls_f PPY,
3924: hr_organization_information HOI,
3925: per_assignments_f ASG,
3926: pay_us_asg_reporting puar,
3927: pay_state_rules SR
3928: WHERE SR.state_code = ''' || l_state || '''

Line 3938: from hr_organization_information HOI2

3934: AND ASG.effective_end_date >= ''' || l_start_date || '''
3935: AND ASG.business_group_id + 0 = ''' || l_business_group_id || '''
3936: AND ((''' || l_state || ''' IN ( ''CA'',''ME''))
3937: OR (not exists (select ''x''
3938: from hr_organization_information HOI2
3939: where HOI2.organization_id = puar.tax_unit_id
3940: AND HOI2.ORG_INFORMATION_CONTEXT = ''1099R Magnetic Report Rules''
3941: AND HOI2.ORG_INFORMATION2 is not null)))
3942: AND HOI.organization_id = puar.tax_unit_id