DBA Data[Home] [Help]

APPS.PA_WORKPLAN_WORKFLOW dependencies on FND_FORM_FUNCTIONS

Line 491: from fnd_compiled_menu_functions f1, fnd_form_functions f2

487: and nvl(fu.end_date, sysdate+1)
488: and trunc(sysdate) between ppp.start_date_active
489: and nvl(ppp.end_date_active, sysdate+1)
490: and pprt.menu_id IN (select f1.menu_id
491: from fnd_compiled_menu_functions f1, fnd_form_functions f2
492: where (f2.function_name = 'PA_PAXPREPR_OPT_WORKPLAN_STR')
493: and f2.function_id = f1.function_id)
494: UNION /*Added this clause for 4482957 */
495: select distinct fu.user_id, fu.user_name, papf.email_address,

Line 527: from fnd_compiled_menu_functions f1, fnd_form_functions f2

523: and nvl(fu.end_date, sysdate+1)
524: and trunc(sysdate) between ppp.start_date_active
525: and nvl(ppp.end_date_active, sysdate+1)
526: and pprt.menu_id IN (select f1.menu_id
527: from fnd_compiled_menu_functions f1, fnd_form_functions f2
528: where (f2.function_name = 'PA_PAXPREPR_OPT_WORKPLAN_STR')
529: and f2.function_id = f1.function_id);
530: */
531:

Line 550: from fnd_compiled_menu_functions f1, fnd_form_functions f2

546: and nvl(fu.end_date, sysdate+1)
547: and trunc(sysdate) between ppp.start_date_active
548: and nvl(ppp.end_date_active, sysdate+1)
549: and pprt.menu_id IN (select f1.menu_id
550: from fnd_compiled_menu_functions f1, fnd_form_functions f2
551: where (f2.function_name = 'PA_PAXPREPR_OPT_WORKPLAN_STR')
552: and f2.function_id = f1.function_id);
553: -- 4586987 end
554: