APPS.PA_WORKPLAN_WORKFLOW_CLIENT dependencies on FND_FORM_FUNCTIONS

Line 566: from fnd_compiled_menu_functions f1, fnd_form_functions f2

562: and nvl(fu.end_date, sysdate+1)
563: and trunc(sysdate) between ppp.start_date_active
564: and nvl(ppp.end_date_active, sysdate+1)
565: and pprt.menu_id IN (select f1.menu_id
566: from fnd_compiled_menu_functions f1, fnd_form_functions f2
567: where (f2.function_name = 'PA_PAXPREPR_OPT_WORKPLAN_STR')
568: and f2.function_id = f1.function_id)
569: UNION /*Added this clause for Approver 4291185 */
570: select distinct fu.user_id, fu.user_name, papf.email_address,

Line 603: from fnd_compiled_menu_functions f1, fnd_form_functions f2

599: and nvl(fu.end_date, sysdate+1)
600: and trunc(sysdate) between ppp.start_date_active
601: and nvl(ppp.end_date_active, sysdate+1)
602: and pprt.menu_id IN (select f1.menu_id
603: from fnd_compiled_menu_functions f1, fnd_form_functions f2
604: where (f2.function_name = 'PA_PAXPREPR_OPT_WORKPLAN_STR')
605: and f2.function_id = f1.function_id);
606: */
607:

Line 626: from fnd_compiled_menu_functions f1, fnd_form_functions f2

622: and nvl(fu.end_date, sysdate+1)
623: and trunc(sysdate) between ppp.start_date_active
624: and nvl(ppp.end_date_active, sysdate+1)
625: and pprt.menu_id IN (select f1.menu_id
626: from fnd_compiled_menu_functions f1, fnd_form_functions f2
627: where (f2.function_name = 'PA_PAXPREPR_OPT_WORKPLAN_STR')
628: and f2.function_id = f1.function_id);
629:
630: -- 4586987 end

Line 655: from fnd_compiled_menu_functions f1, fnd_form_functions f2

651: and nvl(fu.end_date, sysdate+1)
652: and trunc(sysdate) between ppp.start_date_active
653: and nvl(ppp.end_date_active, sysdate+1)
654: and pprt.menu_id IN (select f1.menu_id
655: from fnd_compiled_menu_functions f1, fnd_form_functions f2
656: where (f2.function_name = 'PA_PAXPREPR_OPT_WORKPLAN_STR'
657: or f2.function_name = 'PA_PAXPREPR_OPT_WORKPLAN_STR_V')
658: and f2.function_id = f1.function_id)
659: UNION

Line 689: from fnd_compiled_menu_functions f1, fnd_form_functions f2

685: and nvl(fu.end_date, sysdate+1)
686: and trunc(sysdate) between ppp.start_date_active
687: and nvl(ppp.end_date_active, sysdate+1)
688: and EXISTS (select f1.menu_id
689: from fnd_compiled_menu_functions f1, fnd_form_functions f2
690: where (f2.function_name = 'PA_PAXPREPR_OPT_WORKPLAN_STR'
691: or f2.function_name = 'PA_PAXPREPR_OPT_WORKPLAN_STR_V')
692: and f2.function_id = f1.function_id)
693: UNION

Line 739: from fnd_compiled_menu_functions f1, fnd_form_functions f2

735: and nvl(fu.end_date, sysdate+1)
736: and trunc(sysdate) between ppp.start_date_active
737: and nvl(ppp.end_date_active, sysdate+1)
738: and pprt.menu_id IN (select f1.menu_id
739: from fnd_compiled_menu_functions f1, fnd_form_functions f2
740: where (f2.function_name = 'PA_PAXPREPR_OPT_WORKPLAN_STR'
741: or f2.function_name = 'PA_PAXPREPR_OPT_WORKPLAN_STR_V')
742: and f2.function_id = f1.function_id);
743: */

Line 763: from fnd_compiled_menu_functions f1, fnd_form_functions f2

759: and nvl(fu.end_date, sysdate+1)
760: and trunc(sysdate) between ppp.start_date_active
761: and nvl(ppp.end_date_active, sysdate+1)
762: and pprt.menu_id IN (select f1.menu_id
763: from fnd_compiled_menu_functions f1, fnd_form_functions f2
764: where (f2.function_name = 'PA_PAXPREPR_OPT_WORKPLAN_STR'
765: or f2.function_name = 'PA_PAXPREPR_OPT_WORKPLAN_STR_V')
766: and f2.function_id = f1.function_id);
767: -- 4586987 end