APPS.PO_DOC_NUMBERING_PKG dependencies on DUAL

Line 538: FROM dual;

534: x_prefix := 'PR';
535:
536: SELECT To_Char(SYSDATE,'YY')
537: INTO x_fiscal_year
538: FROM dual;
539:
540: BEGIN
541: SELECT lookup_code
542: INTO x_agency_identifier

Line 1039: FROM dual;

1035: x_prefix := 'SOL';
1036:
1037: SELECT To_Char(SYSDATE,'YY')
1038: INTO x_fiscal_year
1039: FROM dual;
1040:
1041: BEGIN
1042: SELECT lookup_code
1043: INTO x_agency_identifier

Line 1508: FROM dual;

1504: x_prefix := 'OR';
1505:
1506: SELECT To_Char(SYSDATE,'YY')
1507: INTO x_fiscal_year
1508: FROM dual;
1509:
1510: BEGIN
1511: SELECT lookup_code
1512: INTO x_agency_identifier

Line 2274: FROM dual;

2270: x_dodaac_hidden := x_dodaac;
2271:
2272: SELECT To_Char(SYSDATE,'YY')
2273: INTO x_fiscal_year
2274: FROM dual;
2275:
2276:
2277: BEGIN
2278: SELECT lookup_code

Line 2830: FROM dual;

2826: x_dodaac_hidden := x_dodaac;
2827:
2828: SELECT To_Char(SYSDATE,'YY')
2829: INTO x_fiscal_year
2830: FROM dual;
2831:
2832:
2833: BEGIN
2834: SELECT lookup_code