DBA Data[Home] [Help]

APPS.PAY_NO_SUPPORT_ORDER dependencies on HR_ORGANIZATION_INFORMATION

Line 147: ,hr_organization_information hoi

143:
144: cursor csr_le_details ( l_leg_emp_id NUMBER ) is
145: select hou.name ,hoi.org_information1
146: from hr_organization_units hou
147: ,hr_organization_information hoi
148: where hou.organization_id = l_leg_emp_id
149: and hoi.organization_id = l_leg_emp_id
150: and hoi.org_information_context = to_char('NO_LEGAL_EMPLOYER_DETAILS');
151:

Line 799: ,hr_organization_information hoi

795: cursor csr_third_party_dest_acc (p_organization_id NUMBER) is
796: select segment6
797: from pay_external_accounts acc
798: ,pay_org_payment_methods_f pay_org
799: ,hr_organization_information hoi
800: where hoi.organization_id = p_organization_id
801: and hoi.org_information_context = 'NO_THIRD_PARTY_PAYMENT'
802: and pay_org.org_payment_method_id = hoi.org_information2
803: and pay_org.pmeth_information1 = 'DESTINATION'