DBA Data[Home] [Help]

APPS.FPA_PROJECT_PVT dependencies on PA_PAGE_LAYOUTS

Line 886: from pa_page_layouts

882:
883:
884: CURSOR c_default_attr is
885: select page_id, pers_function_name
886: from pa_page_layouts
887: where page_id = 51;
888:
889: CURSOR c_pl_cycle_attr is
890: select pap.page_id, obj.pers_function_name

Line 891: from pa_page_layouts pap, pa_object_page_layouts obj

887: where page_id = 51;
888:
889: CURSOR c_pl_cycle_attr is
890: select pap.page_id, obj.pers_function_name
891: from pa_page_layouts pap, pa_object_page_layouts obj
892: where obj.OBJECT_TYPE = 'PA_PROJECTS'
893: and obj.object_id = p_planning_cycle_id
894: and pap.page_id = obj.page_id;
895:

Line 934: from pa_page_layouts pap, pa_object_page_layouts obj

930: IS
931: l_page_id NUMBER;
932: CURSOR c_pl_cycle_attr is
933: select pap.page_id
934: from pa_page_layouts pap, pa_object_page_layouts obj
935: where obj.OBJECT_TYPE = 'PA_PROJECTS'
936: and obj.object_id = p_planning_cycle_id
937: and pap.page_id = obj.page_id;
938:

Line 973: from pa_page_layouts

969: l_pers_function_name VARCHAR2(50);
970:
971: CURSOR c_default_attr is
972: select page_id, pers_function_name
973: from pa_page_layouts
974: where page_id = 51;
975:
976: CURSOR c_pl_cycle_attr is
977: select pap.page_id, obj.pers_function_name

Line 978: from pa_page_layouts pap, pa_object_page_layouts obj

974: where page_id = 51;
975:
976: CURSOR c_pl_cycle_attr is
977: select pap.page_id, obj.pers_function_name
978: from pa_page_layouts pap, pa_object_page_layouts obj
979: where obj.OBJECT_TYPE = 'PA_PROJECTS'
980: and obj.object_id = p_planning_cycle_id
981: and pap.page_id = obj.page_id;
982: