APPS.CSC_PLAN_ASSIGNMENT_PKG dependencies on DUAL

Line 1650: from sys.dual;

1646: RAISE FND_API.G_EXC_ERROR;
1647: END IF;
1648: select sysdate
1649: into l_ins_start_date
1650: from sys.dual;
1651:
1652: FORALL i in 1..p_plan_id_tbl.count
1653: INSERT INTO csc_cust_plans (
1654: CUST_PLAN_ID, PLAN_ID, PARTY_ID,

Line 1679: FROM SYS.DUAL

1675: NULL, NULL, NULL,
1676: NULL, NULL, NULL,
1677: NULL, NULL, NULL,
1678: NULL, 1
1679: FROM SYS.DUAL
1680: WHERE NOT EXISTS ( select 1
1681: from csc_cust_plans
1682: where plan_id = p_plan_id_tbl(i)
1683: and party_id = p_party_id_tbl(i)

Line 1689: from sys.dual;

1685: );
1686:
1687: select sysdate
1688: into l_ins_end_date
1689: from sys.dual;
1690:
1691: FORALL i in 1..p_party_id_tbl.count
1692: INSERT INTO csc_cust_plans_audit (
1693: PLAN_AUDIT_ID, PLAN_ID, PARTY_ID,

Line 1716: FROM SYS.DUAL

1712: NULL, NULL, NULL,
1713: NULL, NULL, NULL,
1714: NULL, NULL, NULL,
1715: NULL, 1
1716: FROM SYS.DUAL
1717: WHERE EXISTS ( select 1
1718: from csc_cust_plans
1719: where plan_id = p_plan_id_tbl(i)
1720: and party_id = p_party_id_tbl(i)

Line 1796: FROM SYS.DUAL;

1792: NULL, NULL, NULL,
1793: NULL, NULL, NULL,
1794: NULL, NULL, NULL,
1795: NULL, 1
1796: FROM SYS.DUAL;
1797:
1798: EXCEPTION
1799: WHEN OTHERS THEN
1800: g_mesg := sqlcode || ' ' || sqlerrm;