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 600: hr_organization_information org

596: select max(org_information8) into g_tax_phone
597: from pay_payrolls_f p,
598: pay_payroll_actions pact,
599: hr_soft_coding_keyflex flex,
600: hr_organization_information org
601: where p.soft_coding_keyflex_id = flex.soft_coding_keyflex_id
602: and org.ORG_INFORMATION_CONTEXT = 'Tax Details References'
603: and org.org_information1 = flex.segment1
604: and p.business_group_id = org.organization_id