APPS.PA_WORKPLAN_WORKFLOW_CLIENT dependencies on FND_FORM_FUNCTIONS

Line 548: from fnd_compiled_menu_functions f1, fnd_form_functions f2

544: and nvl(fu.end_date, sysdate+1)
545: and trunc(sysdate) between ppp.start_date_active
546: and nvl(ppp.end_date_active, sysdate+1)
547: and pprt.menu_id IN (select f1.menu_id
548: from fnd_compiled_menu_functions f1, fnd_form_functions f2
549: where (f2.function_name = 'PA_PAXPREPR_OPT_WORKPLAN_STR')
550: and f2.function_id = f1.function_id)
551: UNION /*Added this clause for Approver 4291185 */
552: select distinct fu.user_id, fu.user_name, papf.email_address,

Line 585: from fnd_compiled_menu_functions f1, fnd_form_functions f2

581: and nvl(fu.end_date, sysdate+1)
582: and trunc(sysdate) between ppp.start_date_active
583: and nvl(ppp.end_date_active, sysdate+1)
584: and pprt.menu_id IN (select f1.menu_id
585: from fnd_compiled_menu_functions f1, fnd_form_functions f2
586: where (f2.function_name = 'PA_PAXPREPR_OPT_WORKPLAN_STR')
587: and f2.function_id = f1.function_id);
588: */
589:

Line 608: from fnd_compiled_menu_functions f1, fnd_form_functions f2

604: and nvl(fu.end_date, sysdate+1)
605: and trunc(sysdate) between ppp.start_date_active
606: and nvl(ppp.end_date_active, sysdate+1)
607: and pprt.menu_id IN (select f1.menu_id
608: from fnd_compiled_menu_functions f1, fnd_form_functions f2
609: where (f2.function_name = 'PA_PAXPREPR_OPT_WORKPLAN_STR')
610: and f2.function_id = f1.function_id);
611:
612: -- 4586987 end

Line 637: from fnd_compiled_menu_functions f1, fnd_form_functions f2

633: and nvl(fu.end_date, sysdate+1)
634: and trunc(sysdate) between ppp.start_date_active
635: and nvl(ppp.end_date_active, sysdate+1)
636: and pprt.menu_id IN (select f1.menu_id
637: from fnd_compiled_menu_functions f1, fnd_form_functions f2
638: where (f2.function_name = 'PA_PAXPREPR_OPT_WORKPLAN_STR'
639: or f2.function_name = 'PA_PAXPREPR_OPT_WORKPLAN_STR_V')
640: and f2.function_id = f1.function_id)
641: UNION

Line 671: from fnd_compiled_menu_functions f1, fnd_form_functions f2

667: and nvl(fu.end_date, sysdate+1)
668: and trunc(sysdate) between ppp.start_date_active
669: and nvl(ppp.end_date_active, sysdate+1)
670: and EXISTS (select f1.menu_id
671: from fnd_compiled_menu_functions f1, fnd_form_functions f2
672: where (f2.function_name = 'PA_PAXPREPR_OPT_WORKPLAN_STR'
673: or f2.function_name = 'PA_PAXPREPR_OPT_WORKPLAN_STR_V')
674: and f2.function_id = f1.function_id)
675: UNION

Line 721: from fnd_compiled_menu_functions f1, fnd_form_functions f2

717: and nvl(fu.end_date, sysdate+1)
718: and trunc(sysdate) between ppp.start_date_active
719: and nvl(ppp.end_date_active, sysdate+1)
720: and pprt.menu_id IN (select f1.menu_id
721: from fnd_compiled_menu_functions f1, fnd_form_functions f2
722: where (f2.function_name = 'PA_PAXPREPR_OPT_WORKPLAN_STR'
723: or f2.function_name = 'PA_PAXPREPR_OPT_WORKPLAN_STR_V')
724: and f2.function_id = f1.function_id);
725: */

Line 745: from fnd_compiled_menu_functions f1, fnd_form_functions f2

741: and nvl(fu.end_date, sysdate+1)
742: and trunc(sysdate) between ppp.start_date_active
743: and nvl(ppp.end_date_active, sysdate+1)
744: and pprt.menu_id IN (select f1.menu_id
745: from fnd_compiled_menu_functions f1, fnd_form_functions f2
746: where (f2.function_name = 'PA_PAXPREPR_OPT_WORKPLAN_STR'
747: or f2.function_name = 'PA_PAXPREPR_OPT_WORKPLAN_STR_V')
748: and f2.function_id = f1.function_id);
749: -- 4586987 end