APPS.PAY_SOE_GLB dependencies on HR_ORGANIZATION_INFORMATION

Line 451: , hr_organization_information orginfo

447: , pay_input_values_f iv
448: , pay_input_values_f_tl ivtl
449: , pay_element_types_f et
450: , pay_element_types_f_tl ettl
451: , hr_organization_information orginfo
452: where aa.assignment_action_id :action_clause
453: and aa.assignment_action_id = rr.assignment_action_id
454: and rr.status in (''P'',''PA'')
455: and rr.run_result_id = rrv.run_result_id

Line 527: from hr_organization_information orginfo

523: AND ( es.LEGISLATION_CODE IS NULL
524: OR es.LEGISLATION_CODE = '':legislation_code'')
525: and es.element_set_name = '''|| p_element_set_name ||''')
526: AND not exists (select 1
527: from hr_organization_information orginfo
528: WHERE orginfo.org_information1 = ''ELEMENT''
529: and orginfo.org_information_context = ''Business Group:SOE Detail''
530: and orginfo.organization_id = :business_group_id
531: and et.element_type_id = to_number(orginfo.org_information2))

Line 620: , hr_organization_information oi

616: , pay_bal_attribute_definitions bad
617: , pay_defined_balances db
618: , pay_balance_dimensions bd
619: , pay_balance_types_tl bt
620: , hr_organization_information oi
621: where bad.attribute_name = p_balance_attribute
622: and ( bad.BUSINESS_GROUP_ID IS NULL
623: OR bad.BUSINESS_GROUP_ID = l_business_group_id)
624: AND ( bad.LEGISLATION_CODE IS NULL

Line 913: , hr_organization_information oi

909: , pay_input_values_f iv
910: , pay_input_values_f_tl ivtl
911: , pay_element_types_f et
912: , pay_element_types_f_tl ettl
913: , hr_organization_information oi
914: where aa.assignment_action_id :action_clause
915: and aa.assignment_action_id = rr.assignment_action_id
916: and rr.status in (''P'',''PA'')
917: and rr.run_result_id = rrv.run_result_id