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

Line 829: l_tax_unit_id hr_organization_information.organization_id%type;

825: p_tax_coll_dist_code VARCHAR2
826: )
827: RETURN BOOLEAN IS
828: l_asg_id per_assignments_f.assignment_id%type;
829: l_tax_unit_id hr_organization_information.organization_id%type;
830: l_psd_rules_exist varchar2(2);
831: l_psd_code varchar2(50);
832: l_psd_code_exsists varchar2(2);
833: l_gre_name hr_all_organization_units.name%type;

Line 859: FROM hr_organization_information

855: substr(puar.jurisdiction_code, 11,2)=nvl(p_tax_coll_dist_code, substr(puar.jurisdiction_code, 11,2))
856: --Added for the Bug 14799833
857: AND NOT EXISTS (
858: SELECT 'Y'
859: FROM hr_organization_information
860: WHERE organization_id = hou.organization_id
861: AND org_information_context = '1099R Magnetic Report Rules')/*
862: AND ( ( pay_us_get_item_data_pkg.GET_CPROG_PARAMETER_VALUE(p_pactid,
863: 'TRANSFER_PERIOD_TYPE') <> 'Yearly'

Line 882: FROM hr_organization_information hoi

878: -- Cursor to check if psd rules are defined for that gre
879:
880: CURSOR c_check_psd_rules_for_gre(l_tax_unit_id number) IS
881: SELECT 'Y'
882: FROM hr_organization_information hoi
883: WHERE hoi.organization_id = l_tax_unit_id AND
884: hoi.org_information_context = 'PSD Reporting Rules'/* AND
885: NOT EXISTS (
886: SELECT 'Y'

Line 887: FROM hr_organization_information

883: WHERE hoi.organization_id = l_tax_unit_id AND
884: hoi.org_information_context = 'PSD Reporting Rules'/* AND
885: NOT EXISTS (
886: SELECT 'Y'
887: FROM hr_organization_information
888: WHERE organization_id = hoi.organization_id
889: AND org_information_context = '1099R Magnetic Report Rules')*/;
890:
891: -- Cursor to get all the psd codes under a gre for which PSD balances exist

Line 915: FROM hr_organization_information hoi

911: -- Cursor to check if that particular psd code is defined in the psd rules for that gre
912:
913: CURSOR c_check_psd_code_for_gre(l_psd_code varchar2, l_tax_unit_id number) IS
914: SELECT 'Y'
915: FROM hr_organization_information hoi
916: WHERE hoi.organization_id = l_tax_unit_id AND
917: hoi.org_information_context = 'PSD Reporting Rules' AND
918: substr(hoi.org_information10,1,6)=l_psd_code;
919:

Line 1180: l_trans_legal_co_id hr_organization_information.organization_id%type;

1176: l_period_start DATE;
1177: l_period_end DATE;
1178: l_tax_coll_dist_code VARCHAR2(2);
1179: l_tax_coll_dist_code_or_all VARCHAR2(3);
1180: l_trans_legal_co_id hr_organization_information.organization_id%type;
1181: l_tax_unit_id hr_organization_information.organization_id%type;
1182: l_gre_name hr_all_organization_units.name%type;
1183: l_archive boolean:= FALSE;
1184: l_w2_reporting_rules_exist number;

Line 1181: l_tax_unit_id hr_organization_information.organization_id%type;

1177: l_period_end DATE;
1178: l_tax_coll_dist_code VARCHAR2(2);
1179: l_tax_coll_dist_code_or_all VARCHAR2(3);
1180: l_trans_legal_co_id hr_organization_information.organization_id%type;
1181: l_tax_unit_id hr_organization_information.organization_id%type;
1182: l_gre_name hr_all_organization_units.name%type;
1183: l_archive boolean:= FALSE;
1184: l_w2_reporting_rules_exist number;
1185: l_psd_reporting_rules_exist number;

Line 1193: select '1' from hr_organization_information

1189: message_text VARCHAR2(32000):= null;
1190: message_preprocess VARCHAR2(2000) := null;
1191:
1192: cursor c_w2_reporting_rules(cp_tax_unit_id in number) is
1193: select '1' from hr_organization_information
1194: where organization_id = cp_tax_unit_id
1195: and org_information_context = 'W2 Reporting Rules';
1196:
1197: cursor c_psd_reporting_rules(cp_tax_unit_id in number) is

Line 1198: select '1' from hr_organization_information

1194: where organization_id = cp_tax_unit_id
1195: and org_information_context = 'W2 Reporting Rules';
1196:
1197: cursor c_psd_reporting_rules(cp_tax_unit_id in number) is
1198: select '1' from hr_organization_information
1199: where organization_id = cp_tax_unit_id
1200: and org_information_context = 'PSD Reporting Rules';
1201:
1202:

Line 1207: hr_organization_information hoi

1203: CURSOR c_get_gre IS
1204: SELECT DISTINCT puar.tax_unit_id
1205: FROM pay_us_asg_reporting puar,
1206: hr_all_organization_units hou,
1207: hr_organization_information hoi
1208: WHERE length(puar.jurisdiction_code)=16 and
1209: substr(puar.jurisdiction_code, 11,2)=nvl(l_tax_coll_dist_code, substr(puar.jurisdiction_code, 11,2)) and
1210: puar.tax_unit_id = hou.organization_id and
1211: hou.business_group_id = l_business_group_id and

Line 1216: FROM hr_organization_information

1212: hoi.organization_id= puar.tax_unit_id and
1213: hoi.org_information_context = 'PSD Reporting Rules' AND
1214: NOT EXISTS (
1215: SELECT 'Y'
1216: FROM hr_organization_information
1217: WHERE organization_id = hoi.organization_id
1218: AND org_information_context = '1099R Magnetic Report Rules');
1219:
1220:

Line 1320: FROM hr_organization_information HOI,

1316:
1317: IF l_period_type <> 'Yearly' then
1318:
1319: p_sqlstr := 'SELECT distinct ASG.person_id
1320: FROM hr_organization_information HOI,
1321: per_all_assignments_f ASG,
1322: pay_us_asg_reporting puar,
1323: pay_state_rules SR
1324: WHERE SR.state_code = '''||l_state_abbrev||'''

Line 1335: from hr_organization_information HOI2

1331: AND HOI.organization_id = puar.tax_unit_id
1332: AND HOI.ORG_INFORMATION_CONTEXT = ''PSD Reporting Rules''
1333: AND asg.assignment_id = puar.assignment_id
1334: AND not exists (select ''x''
1335: from hr_organization_information HOI2
1336: where HOI2.organization_id = puar.tax_unit_id
1337: AND HOI2.ORG_INFORMATION_CONTEXT = ''1099R Magnetic Report Rules''
1338: AND HOI2.ORG_INFORMATION2 is not null)
1339: AND ASG.payroll_id is not null

Line 1367: FROM hr_organization_information hoi

1363: AND paf.effective_start_date <= ppa.effective_date
1364: AND paf.effective_end_date >= ppa.start_date
1365: AND paa.action_status = ''C''
1366: AND NOT EXISTS ( SELECT ''x''
1367: FROM hr_organization_information hoi
1368: WHERE hoi.organization_id = paa.tax_unit_id
1369: AND hoi.org_information_context = ''1099R Magnetic Report Rules''
1370: )
1371: AND EXISTS ( SELECT ''x''

Line 1372: FROM hr_organization_information hoi

1368: WHERE hoi.organization_id = paa.tax_unit_id
1369: AND hoi.org_information_context = ''1099R Magnetic Report Rules''
1370: )
1371: AND EXISTS ( SELECT ''x''
1372: FROM hr_organization_information hoi
1373: WHERE hoi.organization_id = paa.tax_unit_id
1374: AND hoi.org_information_context = ''PSD Reporting Rules''
1375: )
1376: ORDER BY to_number(paa.serial_number)';

Line 2116: from hr_organization_information hoi

2112: IS
2113: select
2114: substr(hoi.org_information10,1,6) value1,
2115: hoi.org_information20 value2
2116: from hr_organization_information hoi
2117: where hoi.organization_id = p_tax_unit_id
2118: and hoi.org_information_context || '' = 'PSD Reporting Rules';
2119:
2120:

Line 2219: hr_organization_information hoi

2215: l_value2,
2216: l_value3
2217: from hr_locations hrl,
2218: hr_all_organization_units hou,
2219: hr_organization_information hoi
2220: where hou.organization_id = p_tax_unit_id
2221: and hoi.organization_id = hou.organization_id
2222: and hoi.org_information_context||'' = 'Employer Identification'
2223: and hrl.location_id = hou.location_id;

Line 2311: from hr_organization_information hoi

2307: --l_value15, /* Job Development Fee (AL) */
2308: l_value16,
2309: l_value19, -- Bug 6928011 access code (PR)
2310: l_value20
2311: from hr_organization_information hoi
2312: where hoi.organization_id = p_tax_unit_id
2313: and hoi.org_information_context || '' = 'W2 Reporting Rules';
2314: exception
2315: when no_data_found then

Line 2399: from hr_organization_information hoi

2395: select hoi.org_information4 value1,
2396: hoi.org_information8 value2
2397: into l_value1,
2398: l_value2
2399: from hr_organization_information hoi
2400: where hoi.organization_id = p_tax_unit_id
2401: and hoi.org_information_context || '' = 'Federal Tax Rules';
2402: exception
2403: when no_data_found then

Line 2455: hr_organization_information target

2451: l_value2,
2452: l_value3
2453: from pay_state_rules rules,
2454: pay_us_states pus,
2455: hr_organization_information target
2456: where substr(rules.jurisdiction_code, 1, 2) =l_state_code
2457: and target.organization_id = p_tax_unit_id
2458: and target.org_information_context || '' = 'State Tax Rules'
2459: and target.org_information1 = pus.state_abbrev

Line 2523: from hr_organization_information hoi

2519: hoi.org_information20 value2
2520: into
2521: l_value1,
2522: l_value2
2523: from hr_organization_information hoi
2524: where hoi.organization_id = p_tax_unit_id
2525: and hoi.org_information_context || '' = 'PSD Reporting Rules';
2526: exception*/
2527: