APPS.PAY_HK_SOE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 29: from hr_organization_information hoi,

25:
26: cursor currency_code
27: (c_business_group_id hr_organization_units.business_group_id%type) is
28: select fcu.currency_code
29: from hr_organization_information hoi,
30: hr_organization_units hou,
31: fnd_currencies fcu
32: where hou.business_group_id = c_business_group_id
33: and hou.organization_id = hoi.organization_id

Line 624: hr_organization_information_v org,

620: 'SELECT org.org_information7 COL02
621: , to_char(sum(prv.result_value)) COL16 /* BUG 5972299 */
622: FROM pay_run_result_values prv,
623: pay_run_results prr,
624: hr_organization_information_v org,
625: pay_input_values_f pivf
626: WHERE prr.status IN (''P'',''PA'')
627: AND org.organization_id = ' || l_business_group_id || '
628: AND org.org_information_context = ''Business Group:SOE Detail''

Line 645: hr_organization_information_v org,

641: SELECT org.org_information7 COL02
642: , to_char(prv.result_value) COL16
643: FROM pay_run_result_values prv,
644: pay_run_results prr,
645: hr_organization_information_v org,
646: pay_input_values_f pivf
647: WHERE prr.status IN (''P'',''PA'')
648: AND org.organization_id = ' || l_business_group_id || '
649: AND org.org_information_context = ''Business Group:SOE Detail''

Line 731: , hr_organization_information_v org

727: , NULL
728: , NULL)
729: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
730: FROM pay_defined_balances pdb
731: , hr_organization_information_v org
732: WHERE org.organization_id = ' || l_business_group_id || '
733: AND org.org_information_context = ''Business Group:SOE Detail''
734: AND org.org_information1 = ''BALANCE''
735: AND pdb.balance_type_id = org.org_information4