DBA Data[Home] [Help]

APPS.HR_SCL_FLEX dependencies on HR_ORGANIZATION_INFORMATION

Line 289: ,hr_organization_information hoi

285: --
286: cursor csr_chk_work_schedule is
287: select null
288: from pay_user_columns puc
289: ,hr_organization_information hoi
290: where ( to_char(puc.user_table_id) = hoi.org_information1
291: or hoi.org_information1 is null)
292: and puc.user_column_id = to_number(p_segment4)
293: and hoi.org_information_context = 'Work Schedule'

Line 558: HR_ORGANIZATION_INFORMATION org,

554: cursor csr_chk_wc_override is
555: Select null
556: From PAY_WC_RATES wcr,
557: PAY_WC_FUNDS wcf,
558: HR_ORGANIZATION_INFORMATION org,
559: PAY_EMP_FED_TAX_V1 ftr
560: where wcr.fund_id = wcf.fund_id
561: and
562: (