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