DBA Data[Home] [Help]

APPS.PAY_AU_PAYMENT_SUMMARY_REPORT dependencies on HR_ORGANIZATION_INFORMATION

Line 609: FROM hr_organization_information hoi

605: AND hlei.information_type = 'HR_SELF_SERVICE_LOC_PREFERENCE'
606: UNION
607: SELECT org_information2 online_opt,
608: 3 sort_col
609: FROM hr_organization_information hoi
610: WHERE hoi.organization_id = c_org_id
611: and hoi.org_information1 = 'PAYMENTSUMMARY'
612: AND hoi.org_information_context = 'HR_SELF_SERVICE_ORG_PREFERENCE'
613: UNION

Line 616: FROM hr_organization_information hoi

612: AND hoi.org_information_context = 'HR_SELF_SERVICE_ORG_PREFERENCE'
613: UNION
614: SELECT org_information2 online_opt,
615: 4 sort_col
616: FROM hr_organization_information hoi
617: WHERE hoi.organization_id = c_bg_id
618: And hoi.org_information1 = 'PAYMENTSUMMARY'
619: AND hoi.org_information_context = 'HR_SELF_SERVICE_BG_PREFERENCE'
620: )