DBA Data[Home] [Help]

APPS.PAY_NL_PAYFILE_SEPA dependencies on HR_ALL_ORGANIZATION_UNITS

Line 119: hr_All_organization_units hou,

115: AND ppm.payee_id is NOT NULL;
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'

Line 559: hr_all_organization_units hou,

555: ,NVL(pea.SEGMENT10,' ')
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,