APPS.PAY_US_MMREF_REPORTING dependencies on HR_ORGANIZATION_UNITS

Line 2012: ,hr_organization_units hou

2008: SELECT DISTINCT paa.tax_unit_id unit_id,ppa1.payroll_action_Id payroll_action,name
2009: FROM pay_assignment_actions paa
2010: ,pay_payroll_actions ppa1 /* year End Pre-process for GRE */
2011: ,pay_payroll_actions ppa /* Year End Pre-process for W-2 */
2012: ,hr_organization_units hou
2013: WHERE
2014: ppa.payroll_action_id = cp_payroll_action_id /* W2 payroll_action_id */
2015: and ppa.payroll_action_id = paa.payroll_action_id
2016: and ppa1.legislative_parameters like ltrim(rtrim(to_char(paa.tax_unit_id))) || ' TRANS%'

Line 2061: l_gre hr_organization_units.name%type;

2057: l_state_code varchar2(2);
2058: l_info varchar2(80);
2059: l_flag varchar2(2) := 'Y';
2060: l_control_num_flag varchar2(2) := 'Y';
2061: l_gre hr_organization_units.name%type;
2062: l_message_preprocess varchar2(80);
2063: l_message_text varchar2(200);
2064: u_message_text varchar2(200);
2065: l_control_number number;