DBA Data[Home] [Help]

APPS.FLM_FLMRFLIN_XMLP_PKG dependencies on DUAL

Line 37: from dual;

33: end if;
34:
35: select mrp_form_query_s.nextval
36: into P_QUERY_ID
37: from dual;
38:
39:
40: select to_number(to_char(to_date('25-10-99','DD-MM-RR'),'D'))
41: into l_org_offset

Line 42: from dual;

38:
39:
40: select to_number(to_char(to_date('25-10-99','DD-MM-RR'),'D'))
41: into l_org_offset
42: from dual;
43:
44: select to_number(to_char(P_DATE_FROM,'D'))
45: into l_date_offset
46: from dual;

Line 46: from dual;

42: from dual;
43:
44: select to_number(to_char(P_DATE_FROM,'D'))
45: into l_date_offset
46: from dual;
47:
48: l_offset := l_date_offset - l_org_offset;
49: if (l_offset < 0) then
50: l_offset := l_offset + 7;