DBA Data[Home] [Help]

APPS.PAY_AU_PAYMENT_SUMMARY_REPORT dependencies on HR_ORGANIZATION_INFORMATION

Line 866: FROM hr_organization_information hoi

862: AND hlei.information_type = 'HR_SELF_SERVICE_LOC_PREFERENCE'
863: UNION
864: SELECT org_information2 online_opt,
865: 3 sort_col
866: FROM hr_organization_information hoi
867: WHERE hoi.organization_id = c_org_id
868: and hoi.org_information1 = 'PAYMENTSUMMARY'
869: AND hoi.org_information_context = 'HR_SELF_SERVICE_ORG_PREFERENCE'
870: UNION

Line 873: FROM hr_organization_information hoi

869: AND hoi.org_information_context = 'HR_SELF_SERVICE_ORG_PREFERENCE'
870: UNION
871: SELECT org_information2 online_opt,
872: 4 sort_col
873: FROM hr_organization_information hoi
874: WHERE hoi.organization_id = c_bg_id
875: And hoi.org_information1 = 'PAYMENTSUMMARY'
876: AND hoi.org_information_context = 'HR_SELF_SERVICE_BG_PREFERENCE'
877: )