APPS.PAY_US_PSD_XML dependencies on HR_ALL_ORGANIZATION_UNITS

Line 833: l_gre_name hr_all_organization_units.name%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;
834: l_effective_date date;
835: l_wah_flag varchar2(2);
836: l_prev_psd_code varchar2(50):=null;
837: message_text VARCHAR2(32000):= null;

Line 850: hr_all_organization_units hou

846:
847: CURSOR c_get_gre IS
848: SELECT DISTINCT puar.tax_unit_id, hou.name
849: FROM pay_us_asg_reporting puar,
850: hr_all_organization_units hou
851: WHERE length(puar.jurisdiction_code)=16 and
852: puar.tax_unit_id = hou.organization_id and
853: hou.business_group_id = p_business_group_id and
854: substr(puar.jurisdiction_code, 11,6) not in ('880000','990000') and

Line 1182: l_gre_name hr_all_organization_units.name%type;

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;
1186: l_report_file_name pay_payroll_actions.magnetic_file_name%type;

Line 1206: hr_all_organization_units hou,

1202:
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

Line 1255: FROM hr_all_organization_units

1251: hr_utility.trace('l_trans_legal_co_id: '||l_trans_legal_co_id);
1252:
1253: SELECT name
1254: INTO l_gre_name
1255: FROM hr_all_organization_units
1256: WHERE organization_id = l_trans_legal_co_id;
1257:
1258: hr_utility.trace('Transmitter Name l_gre_name: '||l_gre_name);
1259:

Line 2218: hr_all_organization_units hou,

2214: into l_value1,
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'