APPS.PAY_GB_PAYROLL_ACTIONS_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 20: G_TAX_PHONE hr_organization_information.org_information8%type;

16: --G_TAX_PHONE_NUM varchar2(40) := 'SCL_PAY_GB_TAX_OFFICE_PHONE_NUMBER';
17:
18: -- variables used for cache values
19: G_PAYROLL_ACTION_ID pay_payroll_actions.payroll_action_id%type;
20: G_TAX_PHONE hr_organization_information.org_information8%type;
21: --
22: -- Balance Items
23: --
24: -- the following are the database items used to retrieve the balances

Line 588: hr_organization_information org

584: select max(org_information8) into g_tax_phone
585: from pay_payrolls_f p,
586: pay_payroll_actions pact,
587: hr_soft_coding_keyflex flex,
588: hr_organization_information org
589: where p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
590: and org.ORG_INFORMATION_CONTEXT = 'Tax Details References'
591: and org.org_information1 = flex.segment1
592: and p.business_group_id = org.organization_id