APPS.PQP_EXPREPLOD_PKG dependencies on DUAL

Line 722: FROM dual;

718: l_temp_date :=Get_Previous_Year_Tax_Date(l_tax_year_start_date,l_maxdate);
719: ELSE
720: Select LAST_DAY(ADD_MONTHS(l_maxdate,(12-to_char(l_maxdate,'MM')-12)))
721: INTO l_temp_date
722: FROM dual;
723: END IF;
724:
725: l_date_detail(l_count1+1).exception_report_id:=l_rep_detail(i).exception_report_id;
726: l_date_detail(l_count1+1).defined_balance_id:=l_rep_detail(i).defined_balance_id;

Line 764: FROM dual;

760: ELSE
761: SELECT LAST_DAY(ADD_MONTHS(l_maxdate,(DECODE(MOD(to_char(l_maxdate,'MM'),3),0,0,1,2,2,1)+
762: (j*-3))))
763: INTO l_temp_date
764: FROM dual;
765: END IF;
766:
767: /*Adds 3 months to iterate quarter*/
768: --Commented for financial tax year change

Line 773: FROM dual; */

769: /*SELECT LAST_DAY(ADD_MONTHS(l_maxdate,
770: (DECODE(MOD(to_char(l_maxdate,'MM'),3),0,0,1,2,2,1)+
771: (j*-3))))
772: INTO temp_date
773: FROM dual; */
774: l_date_detail(l_count1+j).pay_date :=l_temp_date;--temp_date--LAST_DAY(ADD_MONTHS(l_maxdate,
775: -- (3-MOD(to_char(l_maxdate,'MM'),3)+(j*-3))));
776: END LOOP ;--end for loop
777: --Previous Month or Average In Months

Line 1457: INTO l_tax_year_start_dt from dual;

1453:
1454: IF l_tax_year_start IS NOT NULL THEN
1455: SELECT fnd_date.canonical_to_date(to_char(p_effective_date,'YYYY') ||
1456: substr(fnd_date.date_to_canonical(l_tax_year_start), 6, 5))
1457: INTO l_tax_year_start_dt from dual;
1458:
1459: --SELECT to_date(to_char(l_tax_year_start,'DD-MON-')|| to_char(p_effective_date,'YYYY'),'DD-MON-YYYY')
1460: --INTO l_tax_year_start_dt from dual;
1461: END IF;

Line 1460: --INTO l_tax_year_start_dt from dual;

1456: substr(fnd_date.date_to_canonical(l_tax_year_start), 6, 5))
1457: INTO l_tax_year_start_dt from dual;
1458:
1459: --SELECT to_date(to_char(l_tax_year_start,'DD-MON-')|| to_char(p_effective_date,'YYYY'),'DD-MON-YYYY')
1460: --INTO l_tax_year_start_dt from dual;
1461: END IF;
1462: Hr_Utility.set_location('l_tax_year_start_dt '||l_tax_year_start_dt, 5);
1463: Hr_Utility.set_location('Leaving: '||l_proc_name, 5);
1464: RETURN l_tax_year_start_dt;

Line 1534: FROM dual;

1530: END IF;
1531:
1532: SELECT SIGN ( ADD_MONTHS(l_tax_year_start_date,3 )-p_effective_date)
1533: INTO l_sign
1534: FROM dual;
1535:
1536: IF l_sign = 1 or l_sign =0 THEN
1537: l_previous_quater_tax_dt:=l_tax_year_start_date-1;
1538: ELSE

Line 1541: FROM dual;

1537: l_previous_quater_tax_dt:=l_tax_year_start_date-1;
1538: ELSE
1539: SELECT SIGN ( ADD_MONTHS(l_tax_year_start_date,6 )-p_effective_date)
1540: INTO l_sign
1541: FROM dual;
1542: IF l_sign = 1 or l_sign =0 THEN
1543: l_previous_quater_tax_dt:=add_months ((l_tax_year_start_date-1),3);
1544: ELSE
1545: SELECT SIGN ( ADD_MONTHS(l_tax_year_start_date,9 )-p_effective_date)

Line 1547: FROM dual;

1543: l_previous_quater_tax_dt:=add_months ((l_tax_year_start_date-1),3);
1544: ELSE
1545: SELECT SIGN ( ADD_MONTHS(l_tax_year_start_date,9 )-p_effective_date)
1546: INTO l_sign
1547: FROM dual;
1548: IF l_sign = 1 or l_sign =0 THEN
1549: l_previous_quater_tax_dt:=add_months ((l_tax_year_start_date-1),6);
1550: ELSE
1551: SELECT SIGN ( ADD_MONTHS(l_tax_year_start_date,12 )-p_effective_date)

Line 1553: FROM dual;

1549: l_previous_quater_tax_dt:=add_months ((l_tax_year_start_date-1),6);
1550: ELSE
1551: SELECT SIGN ( ADD_MONTHS(l_tax_year_start_date,12 )-p_effective_date)
1552: INTO l_sign
1553: FROM dual;
1554: IF l_sign = 1 or l_sign =0 THEN
1555: l_previous_quater_tax_dt:=add_months ((l_tax_year_start_date-1),9);
1556: END IF;
1557: END IF;