DBA Data[Home] [Help]

APPS.PAY_NL_PAYFILE_SEPA dependencies on HR_ORGANIZATION_INFORMATION

Line 120: hr_organization_information hoi

116: --
117: cursor csr_org_count (p_org_id pay_personal_payment_methods_f.payee_id%TYPE) is
118: select count(*) from
119: hr_All_organization_units hou,
120: hr_organization_information hoi
121: where hou.organization_id = p_org_id
122: and hoi.organization_id = hou.organization_id
123: and hoi.org_information_context = 'CLASS'
124: and hoi.org_information1 = 'NL_PAYEE_OVERRIDE'

Line 560: hr_organization_information hoi,

556: ,NVL(pea.SEGMENT9,' ')
557: ,hoi.org_information4
558: from
559: hr_all_organization_units hou,
560: hr_organization_information hoi,
561: pay_org_payment_methods_f popmf,
562: PAY_ORG_PAY_METHOD_USAGES_F popmu,
563: PAY_ALL_PAYROLLS_F papf,
564: PAY_EXTERNAL_ACCOUNTS pea,