DBA Data[Home] [Help]

APPS.PAY_ACTION_CONTEXTS_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 46: FROM HR_ORGANIZATION_INFORMATION ou,

42: --
43: begin
44: SELECT ou.org_information9
45: INTO g_legislation_code
46: FROM HR_ORGANIZATION_INFORMATION ou,
47: HR_ORGANIZATION_UNITS o,
48: PAY_PAYROLL_ACTIONS pa
49: WHERE pa.payroll_action_id = p_pay_act_id
50: and o.business_group_id = pa.business_group_id

Line 235: FROM HR_ORGANIZATION_INFORMATION oi

231: if g_legislation_code = 'US' then
232: begin
233: SELECT oi.org_information5
234: INTO l_tax_group
235: FROM HR_ORGANIZATION_INFORMATION oi
236: WHERE upper(oi.org_information_context) = 'FEDERAL TAX RULES'
237: and oi.organization_id = p_tax_unit_id;
238: exception
239: when NO_DATA_FOUND then