DBA Data[Home] [Help]

APPS.PAY_US_W2_INFO_PKG dependencies on HR_US_W2_REP

Line 389: hr_us_w2_rep.get_per_item(p_asg_action_id,

385: decode(middle_name,null,' ',
386: ' '||substr(middle_name,1,1)||' ') ||
387: pre_name_adjunt emp_name,
388: last_name , -- Bug 4523389
389: hr_us_w2_rep.get_per_item(p_asg_action_id,
390: 'A_PER_SUFFIX') emp_suffix,
391: /* Bug 5575567
392: decode(pa.address_line1,null,null,pa.address_line1 ||'\r')||
393: decode(pa.address_line2,null,null,pa.address_line2||'\r') ||

Line 626: hr_us_w2_rep.get_agent_tax_unit_id(l_business_group_id

622:
623: hr_utility.trace('Business Group id ' ||l_business_group_id);
624:
625: IF l_business_group_id is not null THEN
626: hr_us_w2_rep.get_agent_tax_unit_id(l_business_group_id
627: ,p_year
628: ,l_agent_tax_unit_id
629: ,l_error_msg);
630: END IF;

Line 730: hr_us_w2_rep.get_per_item(p_asg_action_id,

726: l_w2_fields.last_name := initcap(l_w2_fields.last_name);
727:
728: select l_first_name||decode(l_middle_name,null,' ',
729: ' '||substr(l_middle_name,1,1)||' ') ||
730: hr_us_w2_rep.get_per_item(p_asg_action_id,
731: 'A_PER_PREFIX' ) into l_w2_fields.emp_name from dual;
732: exception when others then null;
733: end ;
734:

Line 855: hr_us_w2_rep.get_county_tax_info('18-015-0000',

851: OR g_occ_tax_rate IS NULL OR g_occ_mh_tax_limit IS NULL
852: OR g_occ_mh_wage_limit IS NULL OR g_mh_tax_wage_limit IS NULL )
853: THEN
854: hr_utility.trace('Getting Mental health and Occupational tax limits');
855: hr_us_w2_rep.get_county_tax_info('18-015-0000',
856: p_year,
857: g_occ_tax_rate,
858: g_mh_tax_rate,
859: g_mh_tax_limit,