DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_EXTR dependencies on DUAL

Line 636: from dual

632: , -1 period_id
633: , PJI_RM_SUM_MAIN.g_null period_name
634: , null start_date
635: , null end_date
636: from dual
637: union all
638: select calendar_id calendar_id
639: , cal_period_id period_id
640: , name period_name

Line 912: select 'F' rule from dual union all

908: 'L', tmp.end_date) curr_date
909: from
910: PJI_FM_EXTR_PLAN tmp,
911: (
912: select 'F' rule from dual union all
913: select 'L' rule from dual
914: ) invert
915: where
916: worker_id = p_worker_id and

Line 913: select 'L' rule from dual

909: from
910: PJI_FM_EXTR_PLAN tmp,
911: (
912: select 'F' rule from dual union all
913: select 'L' rule from dual
914: ) invert
915: where
916: worker_id = p_worker_id and
917: time_dangling_flag is null