APPS.PAY_US_MMREF_LOCAL dependencies on HR_ORGANIZATION_UNITS

Line 1431: ,hr_organization_units hou

1427: SELECT DISTINCT paa.tax_unit_id unit_id,ppa1.payroll_action_Id payroll_action,name
1428: FROM pay_assignment_actions paa
1429: ,pay_payroll_actions ppa1 /* year End Pre-process for GRE */
1430: ,pay_payroll_actions ppa /* Year End Pre-process for W-2 */
1431: ,hr_organization_units hou
1432: WHERE
1433: ppa.payroll_action_id = cp_payroll_action_id /* W2 payroll_action_id */
1434: and ppa.payroll_action_id = paa.payroll_action_id
1435: and ppa1.legislative_parameters like ltrim(rtrim(to_char(paa.tax_unit_id))) || ' TRANS%'

Line 1473: l_gre hr_organization_units.name%type;

1469: l_payroll_action_id number;
1470: l_state_code varchar2(2);
1471: l_info varchar2(80);
1472: l_flag varchar2(2) := 'Y';
1473: l_gre hr_organization_units.name%type;
1474: l_message_preprocess varchar2(80);
1475: l_message_text varchar2(200);
1476: u_message_text varchar2(200);
1477: BEGIN