APPS.PAY_US_MMREF_LOCAL dependencies on HR_ORGANIZATION_UNITS

Line 1430: ,hr_organization_units hou

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

Line 1472: l_gre hr_organization_units.name%type;

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