APPS.PQP_EXPREPLOD_PKG dependencies on DUAL

Line 565: FROM dual;

561: l_temp_date :=Get_Previous_Year_Tax_Date(l_tax_year_start_date,l_maxdate);
562: ELSE
563: Select LAST_DAY(ADD_MONTHS(l_maxdate,(12-to_char(l_maxdate,'MM')-12)))
564: INTO l_temp_date
565: FROM dual;
566: END IF;
567:
568: l_date_detail(l_count1+1).exception_report_id:=l_rep_detail(i).exception_report_id;
569: l_date_detail(l_count1+1).defined_balance_id:=l_rep_detail(i).defined_balance_id;

Line 607: FROM dual;

603: ELSE
604: SELECT LAST_DAY(ADD_MONTHS(l_maxdate,(DECODE(MOD(to_char(l_maxdate,'MM'),3),0,0,1,2,2,1)+
605: (j*-3))))
606: INTO l_temp_date
607: FROM dual;
608: END IF;
609:
610: /*Adds 3 months to iterate quarter*/
611: --Commented for financial tax year change

Line 616: FROM dual; */

612: /*SELECT LAST_DAY(ADD_MONTHS(l_maxdate,
613: (DECODE(MOD(to_char(l_maxdate,'MM'),3),0,0,1,2,2,1)+
614: (j*-3))))
615: INTO temp_date
616: FROM dual; */
617: l_date_detail(l_count1+j).pay_date :=l_temp_date;--temp_date--LAST_DAY(ADD_MONTHS(l_maxdate,
618: -- (3-MOD(to_char(l_maxdate,'MM'),3)+(j*-3))));
619: END LOOP ;--end for loop
620: --Previous Month or Average In Months

Line 1277: INTO l_tax_year_start_dt from dual;

1273:
1274: IF l_tax_year_start IS NOT NULL THEN
1275: SELECT fnd_date.canonical_to_date(to_char(p_effective_date,'YYYY') ||
1276: substr(fnd_date.date_to_canonical(l_tax_year_start), 6, 5))
1277: INTO l_tax_year_start_dt from dual;
1278:
1279: --SELECT to_date(to_char(l_tax_year_start,'DD-MON-')|| to_char(p_effective_date,'YYYY'),'DD-MON-YYYY')
1280: --INTO l_tax_year_start_dt from dual;
1281: END IF;

Line 1280: --INTO l_tax_year_start_dt from dual;

1276: substr(fnd_date.date_to_canonical(l_tax_year_start), 6, 5))
1277: INTO l_tax_year_start_dt from dual;
1278:
1279: --SELECT to_date(to_char(l_tax_year_start,'DD-MON-')|| to_char(p_effective_date,'YYYY'),'DD-MON-YYYY')
1280: --INTO l_tax_year_start_dt from dual;
1281: END IF;
1282: Hr_Utility.set_location('l_tax_year_start_dt '||l_tax_year_start_dt, 5);
1283: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);
1284: RETURN l_tax_year_start_dt;

Line 1354: FROM dual;

1350: END IF;
1351:
1352: SELECT SIGN ( ADD_MONTHS(l_tax_year_start_date,3 )-p_effective_date)
1353: INTO l_sign
1354: FROM dual;
1355:
1356: IF l_sign = 1 or l_sign =0 THEN
1357: l_previous_quater_tax_dt:=l_tax_year_start_date-1;
1358: ELSE

Line 1361: FROM dual;

1357: l_previous_quater_tax_dt:=l_tax_year_start_date-1;
1358: ELSE
1359: SELECT SIGN ( ADD_MONTHS(l_tax_year_start_date,6 )-p_effective_date)
1360: INTO l_sign
1361: FROM dual;
1362: IF l_sign = 1 or l_sign =0 THEN
1363: l_previous_quater_tax_dt:=add_months ((l_tax_year_start_date-1),3);
1364: ELSE
1365: SELECT SIGN ( ADD_MONTHS(l_tax_year_start_date,9 )-p_effective_date)

Line 1367: FROM dual;

1363: l_previous_quater_tax_dt:=add_months ((l_tax_year_start_date-1),3);
1364: ELSE
1365: SELECT SIGN ( ADD_MONTHS(l_tax_year_start_date,9 )-p_effective_date)
1366: INTO l_sign
1367: FROM dual;
1368: IF l_sign = 1 or l_sign =0 THEN
1369: l_previous_quater_tax_dt:=add_months ((l_tax_year_start_date-1),6);
1370: ELSE
1371: SELECT SIGN ( ADD_MONTHS(l_tax_year_start_date,12 )-p_effective_date)

Line 1373: FROM dual;

1369: l_previous_quater_tax_dt:=add_months ((l_tax_year_start_date-1),6);
1370: ELSE
1371: SELECT SIGN ( ADD_MONTHS(l_tax_year_start_date,12 )-p_effective_date)
1372: INTO l_sign
1373: FROM dual;
1374: IF l_sign = 1 or l_sign =0 THEN
1375: l_previous_quater_tax_dt:=add_months ((l_tax_year_start_date-1),9);
1376: END IF;
1377: END IF;