DBA Data[Home] [Help]

APPS.PAY_US_MMREF_REPORTING dependencies on HR_ORGANIZATION_UNITS

Line 2504: ,hr_organization_units hou

2500: SELECT DISTINCT paa.tax_unit_id unit_id,ppa1.payroll_action_Id payroll_action,name
2501: FROM pay_assignment_actions paa
2502: ,pay_payroll_actions ppa1 /* year End Pre-process for GRE */
2503: ,pay_payroll_actions ppa /* Year End Pre-process for W-2 */
2504: ,hr_organization_units hou
2505: WHERE
2506: ppa.payroll_action_id = cp_payroll_action_id /* W2 payroll_action_id */
2507: and ppa.payroll_action_id = paa.payroll_action_id
2508: and ppa1.legislative_parameters like ltrim(rtrim(to_char(paa.tax_unit_id))) || ' TRANS%'

Line 2553: l_gre hr_organization_units.name%type;

2549: l_state_code varchar2(2);
2550: l_info varchar2(80);
2551: l_flag varchar2(2) := 'Y';
2552: l_control_num_flag varchar2(2) := 'Y';
2553: l_gre hr_organization_units.name%type;
2554: l_message_preprocess varchar2(300); -- Bug# 14286448 Gre length issue
2555: l_message_text varchar2(200);
2556: u_message_text varchar2(200);
2557: l_control_number number;