[Home] [Help]
333: AND fpov.profile_option_value = TO_CHAR (psp.security_profile_id)
334: AND ((psp.view_all_organizations_flag = 'Y'
335: AND psp.business_group_id IS NOT NULL
336: AND EXISTS (SELECT 1
337: FROM hr_operating_units hr
338: WHERE hr.business_group_id = psp.business_group_id
339: AND hr.usable_flag IS NULL
340: AND hr.organization_id =
341: l_txn_hdr_rec.org_id))
343: AND psp.business_group_id IS NULL)
344: OR (NVL (psp.view_all_organizations_flag, 'N') <> 'Y'
345: AND EXISTS (SELECT 1
346: FROM per_organization_list per,
347: hr_operating_units hr
348: WHERE per.security_profile_id = psp.security_profile_id
349: AND hr.organization_id = per.organization_id
350: AND hr.usable_flag IS NULL
351: AND per.organization_id = l_txn_hdr_rec.org_id)))
419: AND fpov.profile_option_value = TO_CHAR (psp.security_profile_id)
420: AND ((psp.view_all_organizations_flag = 'Y'
421: AND psp.business_group_id IS NOT NULL
422: AND EXISTS (SELECT 1
423: FROM hr_operating_units hr
424: WHERE hr.business_group_id = psp.business_group_id
425: AND hr.usable_flag IS NULL
426: AND hr.organization_id = l_txn_hdr_rec.org_id))
427: OR (psp.view_all_organizations_flag = 'Y'
428: AND psp.business_group_id IS NULL)
429: OR (NVL (psp.view_all_organizations_flag, 'N') <> 'Y'
430: AND EXISTS (SELECT 1
431: FROM per_organization_list per,
432: hr_operating_units hr
433: WHERE per.security_profile_id = psp.security_profile_id
434: AND hr.organization_id = per.organization_id
435: AND hr.usable_flag IS NULL
436: AND per.organization_id = l_txn_hdr_rec.org_id)))
505: AND fpov.profile_option_value = TO_CHAR (psp.security_profile_id)
506: AND ((psp.view_all_organizations_flag = 'Y'
507: AND psp.business_group_id IS NOT NULL
508: AND EXISTS (SELECT 1
509: FROM hr_operating_units hr
510: WHERE hr.business_group_id = psp.business_group_id
511: AND hr.usable_flag IS NULL
512: AND hr.organization_id = l_txn_hdr_rec.org_id))
513: OR (psp.view_all_organizations_flag = 'Y'
514: AND psp.business_group_id IS NULL)
515: OR (NVL (psp.view_all_organizations_flag, 'N') <> 'Y'
516: AND EXISTS (SELECT 1
517: FROM per_organization_list per,
518: hr_operating_units hr
519: WHERE per.security_profile_id = psp.security_profile_id
520: AND hr.organization_id = per.organization_id
521: AND hr.usable_flag IS NULL
522: AND per.organization_id = l_txn_hdr_rec.org_id)))
592: AND fpov.profile_option_value = TO_CHAR (psp.security_profile_id)
593: AND ((psp.view_all_organizations_flag = 'Y'
594: AND psp.business_group_id IS NOT NULL
595: AND EXISTS (SELECT 1
596: FROM hr_operating_units hr
597: WHERE hr.business_group_id = psp.business_group_id
598: AND hr.usable_flag IS NULL
599: AND hr.organization_id = l_txn_hdr_rec.org_id))
600: OR (psp.view_all_organizations_flag = 'Y'
601: AND psp.business_group_id IS NULL)
602: OR (NVL (psp.view_all_organizations_flag, 'N') <> 'Y'
603: AND EXISTS (SELECT 1
604: FROM per_organization_list per,
605: hr_operating_units hr
606: WHERE per.security_profile_id = psp.security_profile_id
607: AND hr.organization_id = per.organization_id
608: AND hr.usable_flag IS NULL
609: AND per.organization_id = l_txn_hdr_rec.org_id)))
675:
676: -- Begin A/c Generator Code ---
677:
678: IF l_bg_process_mode = 'Y' THEN
679: --Changed from ozf_sys_parameters_all to hr_operating_units
680: SELECT chart_of_accounts_id
681: INTO l_chart_of_accounts_id
682: FROM gl_sets_of_books sob,
683: hr_operating_units hr
679: --Changed from ozf_sys_parameters_all to hr_operating_units
680: SELECT chart_of_accounts_id
681: INTO l_chart_of_accounts_id
682: FROM gl_sets_of_books sob,
683: hr_operating_units hr
684: WHERE hr.set_of_books_id = sob.set_of_books_id
685: AND hr.organization_id = l_txn_hdr_rec.org_id;
686:
687: l_debug_flag := fnd_profile.value('ACCOUNT_GENERATOR:DEBUG_MODE');