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 623: hr_organization_information_v org,

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

Line 644: hr_organization_information_v org,

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

Line 730: , hr_organization_information_v org

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