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 18: 01-Feb-2006 sudedas 115.59 4890376 Removing hr_organization_information

14: for improving performance
15: 14-Mar-2007 saurgupt 115.62 5152728 Changed the range_cursor and action_creation to
16: improve perf. In range_cursor, removed pay_payrolls_f.
17: 07-Apr-2006 sudedas 115.60 4344959 changing preprocess_check, cursor (c_chk_asg_wp)
18: 01-Feb-2006 sudedas 115.59 4890376 Removing hr_organization_information
19: from action_creation cursors (including
20: LA,CT) as the checks are there for range_cursor
21: 24-JAN-2006 sackumar 115.58 4869678 Modified the c_get_latest_asg cursor in
22: archive_data procedure.removed the +0 from

Line 998: hr_organization_information HOI_PR

994: ppa.effective_date effective_end_date
995: FROM per_all_assignments_f ASG,
996: pay_assignment_actions paa,
997: pay_payroll_actions ppa,
998: hr_organization_information HOI_PR
999: WHERE ppa.effective_date between l_period_start and l_period_end
1000: AND ppa.action_type in ('R', 'Q', 'V', 'B', 'I')
1001: AND paa.payroll_action_id = ppa.payroll_action_id
1002: AND hoi_pr.organization_id = paa.tax_unit_id

Line 1026: from hr_organization_information HOI

1022: and puar.tax_unit_id = hoi_pr.organization_id
1023: and SR.state_code = l_state)
1024: /* there shouldn't be any dependency on state tax rules
1025: AND EXISTS (select 'x'
1026: from hr_organization_information HOI
1027: where hoi.organization_id = hoi_pr.organization_id
1028: AND HOI.org_information_context = 'State Tax Rules'
1029: AND HOI.org_information1 = l_state
1030: AND NVL(HOI.org_information16, 'No') = 'No'

Line 1045: hr_organization_information HOI_PR,

1041: ppa.effective_date effective_end_date
1042: FROM per_all_assignments_f ASG,
1043: pay_assignment_actions paa,
1044: pay_payroll_actions ppa,
1045: hr_organization_information HOI_PR,
1046: pay_population_ranges ppr
1047: WHERE ppa.effective_date between l_period_start and l_period_end
1048: AND ppa.action_type in ('R', 'Q', 'V', 'B', 'I')
1049: AND paa.payroll_action_id = ppa.payroll_action_id

Line 1077: from hr_organization_information HOI

1073: and puar.tax_unit_id = hoi_pr.organization_id
1074: and SR.state_code = l_state)
1075: /* there shouldn't be any dependency on state tax rules
1076: AND EXISTS (select 'x'
1077: from hr_organization_information HOI
1078: where hoi.organization_id = hoi_pr.organization_id
1079: AND HOI.org_information_context = 'State Tax Rules'
1080: AND HOI.org_information1 = l_state
1081: AND NVL(HOI.org_information16, 'No') = 'No'

Line 1089: FROM hr_organization_information

1085: /* California Multi Wage Plan Requirement */
1086:
1087: CURSOR c_chk_gre_wp (p_tax_unit_id number) IS
1088: SELECT count(*) ct
1089: FROM hr_organization_information
1090: WHERE organization_id = p_tax_unit_id
1091: AND org_information_context = 'PAY_US_STATE_WAGE_PLAN_INFO'
1092: AND org_information1 = 'CA'
1093: AND org_information4 = 'Y';

Line 1334: from hr_organization_information

1330: then
1331: begin
1332: select 'Y'
1333: into l_1099R_ind
1334: from hr_organization_information
1335: where organization_id = l_tax_unit_id
1336: and org_information_context = '1099R Magnetic Report Rules';
1337: exception
1338: when no_data_found then

Line 2033: FROM hr_organization_information hoi

2029:
2030:
2031: CURSOR c_gre_wage_plan_code IS
2032: SELECT hoi.org_information3 wage_plan
2033: FROM hr_organization_information hoi
2034: WHERE hoi.org_information_context = 'PAY_US_STATE_WAGE_PLAN_INFO'
2035: AND hoi.organization_id = taxunitid
2036: AND hoi.org_information1 = g_sqwl_state
2037: AND hoi.org_information4 = 'Y';

Line 2460: FROM hr_organization_information orgi,

2456: AND paei.information_type = 'PAY_US_ASG_STATE_WAGE_PLAN_CD'
2457: AND paei.aei_information1 = l_state /* Added for performance improvement Bug# 4344959 */
2458: AND paei.assignment_id = paf.assignment_id
2459: AND NOT EXISTS (SELECT null
2460: FROM hr_organization_information orgi,
2461: hr_soft_coding_keyflex sft
2462: WHERE orgi.organization_id = to_number(sft.segment1)
2463: AND sft.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
2464: AND orgi.org_information1 = paei.aei_information1

Line 2477: FROM hr_organization_information orgi

2473: SELECT count(*) ct
2474: FROM hr_legal_entities org
2475: WHERE org.business_group_id = l_bus_group_id
2476: AND EXISTS (SELECT null
2477: FROM hr_organization_information orgi
2478: WHERE organization_id = org.organization_id
2479: AND org_information_context = 'PAY_US_STATE_WAGE_PLAN_INFO'
2480: AND org_information1 = 'CA')
2481: AND NOT EXISTS ( SELECT null

Line 2482: FROM hr_organization_information orgi

2478: WHERE organization_id = org.organization_id
2479: AND org_information_context = 'PAY_US_STATE_WAGE_PLAN_INFO'
2480: AND org_information1 = 'CA')
2481: AND NOT EXISTS ( SELECT null
2482: FROM hr_organization_information orgi
2483: WHERE organization_id = org.organization_id
2484: AND org_information_context = 'PAY_US_STATE_WAGE_PLAN_INFO'
2485: AND org_information1 = 'CA'
2486: AND org_information4 = 'Y');

Line 2495: FROM hr_organization_information a

2491: (select distinct
2492: a.organization_id,
2493: a.org_information1,
2494: a.org_information3
2495: FROM hr_organization_information a
2496: WHERE org_information_context = 'PAY_US_STATE_WAGE_PLAN_INFO') b
2497: WHERE org.business_group_id = l_bus_group_id
2498: AND b.organization_id = org.organization_id
2499: AND 1 < ( SELECT count(*)

Line 2500: FROM hr_organization_information orgi

2496: WHERE org_information_context = 'PAY_US_STATE_WAGE_PLAN_INFO') b
2497: WHERE org.business_group_id = l_bus_group_id
2498: AND b.organization_id = org.organization_id
2499: AND 1 < ( SELECT count(*)
2500: FROM hr_organization_information orgi
2501: WHERE organization_id = org.organization_id
2502: AND org_information_context = 'PAY_US_STATE_WAGE_PLAN_INFO'
2503: AND org_information1 = b.org_information1
2504: AND org_information3 = b.org_information3);

Line 2508: l_wage_plan_code hr_organization_information.org_information3%TYPE;

2504: AND org_information3 = b.org_information3);
2505:
2506:
2507: l_flag VARCHAR2(4) ;
2508: l_wage_plan_code hr_organization_information.org_information3%TYPE;
2509: l_company_sui_id hr_organization_information.org_information2%TYPE;
2510: l_counter NUMBER := 0 ;
2511: l_distinct_wage_plan_code NUMBER := 0 ;
2512:

Line 2509: l_company_sui_id hr_organization_information.org_information2%TYPE;

2505:
2506:
2507: l_flag VARCHAR2(4) ;
2508: l_wage_plan_code hr_organization_information.org_information3%TYPE;
2509: l_company_sui_id hr_organization_information.org_information2%TYPE;
2510: l_counter NUMBER := 0 ;
2511: l_distinct_wage_plan_code NUMBER := 0 ;
2512:
2513:

Line 2809: select '1' from hr_organization_information

2805:
2806: l_preprocess_flag BOOLEAN := FALSE;
2807:
2808: cursor c_reporting_rules(cp_tax_unit_id in number) is
2809: select '1' from hr_organization_information
2810: where organization_id = cp_tax_unit_id
2811: and org_information_context = 'W2 Reporting Rules';
2812: begin
2813:

Line 2838: FROM hr_organization_information HOI,

2834: /* End of Bug 1220213 */
2835:
2836: if (l_state = 'LA' and l_report_cat = 'RTLAQ') then
2837: sqwl_range := 'SELECT distinct ASG.person_id
2838: FROM hr_organization_information HOI,
2839: per_assignments_f ASG,
2840: pay_us_asg_reporting puar,
2841: pay_state_rules SR
2842: WHERE SR.state_code = ''' || l_state || '''

Line 2854: from hr_organization_information HOI2

2850: AND HOI.ORG_INFORMATION_CONTEXT = ''State Tax Rules''
2851: AND HOI.ORG_INFORMATION1 = ''' || l_state || '''
2852: AND NVL(HOI.ORG_INFORMATION16,''No'') = ''Yes''
2853: AND not exists (select ''x''
2854: from hr_organization_information HOI2
2855: where HOI2.organization_id = puar.tax_unit_id
2856: AND HOI2.ORG_INFORMATION_CONTEXT = ''1099R Magnetic Report Rules''
2857: AND HOI2.ORG_INFORMATION2 is not null)
2858: AND ASG.payroll_id is not null

Line 2864: FROM hr_organization_information HOI,

2860: ORDER BY ASG.person_id';
2861:
2862: elsif (l_state = 'CT' and l_report_cat = 'RTCTN') then
2863: sqwl_range := 'SELECT distinct ASG.person_id
2864: FROM hr_organization_information HOI,
2865: per_assignments_f ASG,
2866: pay_us_asg_reporting puar,
2867: pay_state_rules SR
2868: WHERE SR.state_code = ''' || l_state || '''

Line 2880: from hr_organization_information HOI2

2876: AND HOI.ORG_INFORMATION_CONTEXT = ''State Tax Rules''
2877: AND HOI.ORG_INFORMATION1 = ''' || l_state || '''
2878: AND NVL(HOI.ORG_INFORMATION20,''No'') = ''Yes''
2879: AND not exists (select ''x''
2880: from hr_organization_information HOI2
2881: where HOI2.organization_id = puar.tax_unit_id
2882: AND HOI2.ORG_INFORMATION_CONTEXT = ''1099R Magnetic Report Rules''
2883: AND HOI2.ORG_INFORMATION2 is not null)
2884: AND ASG.payroll_id is not null

Line 2899: FROM hr_organization_information HOI,

2895: END IF;
2896: IF ((l_preprocess_flag = TRUE AND l_state = 'CA') OR
2897: l_state <> 'CA') THEN
2898: sqwl_range := 'SELECT distinct ASG.person_id
2899: FROM hr_organization_information HOI,
2900: per_assignments_f ASG,
2901: pay_us_asg_reporting puar,
2902: pay_state_rules SR
2903: WHERE SR.state_code = ''' || l_state || '''

Line 2912: from hr_organization_information HOI2

2908: AND ASG.effective_end_date >= ''' || l_start_date || '''
2909: AND ASG.business_group_id + 0 = ''' || l_business_group_id || '''
2910: AND ((''' || l_state || ''' IN ( ''CA'',''ME''))
2911: OR (not exists (select ''x''
2912: from hr_organization_information HOI2
2913: where HOI2.organization_id = puar.tax_unit_id
2914: AND HOI2.ORG_INFORMATION_CONTEXT = ''1099R Magnetic Report Rules''
2915: AND HOI2.ORG_INFORMATION2 is not null)))
2916: AND HOI.organization_id = puar.tax_unit_id

Line 2928: hr_organization_information HOI,

2924:
2925: /* commented by saurgupt for testing
2926: sqwl_range := 'SELECT distinct ASG.person_id
2927: FROM pay_payrolls_f PPY,
2928: hr_organization_information HOI,
2929: per_assignments_f ASG,
2930: pay_us_asg_reporting puar,
2931: pay_state_rules SR
2932: WHERE SR.state_code = ''' || l_state || '''

Line 2942: from hr_organization_information HOI2

2938: AND ASG.effective_end_date >= ''' || l_start_date || '''
2939: AND ASG.business_group_id + 0 = ''' || l_business_group_id || '''
2940: AND ((''' || l_state || ''' IN ( ''CA'',''ME''))
2941: OR (not exists (select ''x''
2942: from hr_organization_information HOI2
2943: where HOI2.organization_id = puar.tax_unit_id
2944: AND HOI2.ORG_INFORMATION_CONTEXT = ''1099R Magnetic Report Rules''
2945: AND HOI2.ORG_INFORMATION2 is not null)))
2946: AND HOI.organization_id = puar.tax_unit_id