APPS.PAY_IN_SOE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 31: ,hr_organization_information hoi

27: IS
28: SELECT hoi2.org_information4
29: FROM per_assignments_f peaf
30: ,hr_soft_coding_keyflex hrscf
31: ,hr_organization_information hoi
32: ,hr_organization_units hou
33: ,hr_organization_information hoi2
34: , pay_assignment_actions paa
35: , pay_payroll_actions ppa

Line 33: ,hr_organization_information hoi2

29: FROM per_assignments_f peaf
30: ,hr_soft_coding_keyflex hrscf
31: ,hr_organization_information hoi
32: ,hr_organization_units hou
33: ,hr_organization_information hoi2
34: , pay_assignment_actions paa
35: , pay_payroll_actions ppa
36: WHERE
37: paa.assignment_action_id = p_assignment_action_id

Line 746: hr_organization_information_v org

742: 'SELECT org.org_information7 COL02
743: , prv.result_value COL16
744: FROM pay_run_result_values prv,
745: pay_run_results prr,
746: hr_organization_information_v org
747: WHERE prr.status IN (''P'',''PA'')
748: AND org.organization_id = ' || l_business_group_id || '
749: AND org.org_information_context = ''Business Group:SOE Detail''
750: AND org.org_information1 = ''ELEMENT''

Line 827: , hr_organization_information_v org

823: , TO_CHAR(pay_balance_pkg.get_value( pdb.defined_balance_id
824: , ' || p_assignment_action_id || ')
825: ,fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
826: FROM pay_defined_balances pdb
827: , hr_organization_information_v org
828: WHERE org.organization_id = ' || l_business_group_id || '
829: AND org.org_information_context = ''Business Group:SOE Detail''
830: AND org.org_information1 = ''BALANCE''
831: AND pdb.balance_type_id = org.org_information4