DBA Data[Home] [Help]

APPS.HRI_PARAMETERS dependencies on DUAL

Line 670: from sys.dual

666:
667: cursor c_bpl is
668: select -1 plan_id
669: ,' ' plan_name
670: from sys.dual
671: union
672: select plan_id
673: ,description plan_name
674: from bisbv_business_plans

Line 778: from dual

774:
775: cursor c_product_category is
776: select '-1' id
777: , ' ' value
778: from dual
779: UNION
780: select id
781: , value
782: from bis_product_categories_v

Line 1012: from dual

1008:
1009: cursor c_country is
1010: select '-1' territory_code
1011: , ' ' country
1012: from dual
1013: union
1014: select territory_code
1015: , territory_short_name country
1016: from fnd_territories_vl

Line 1023: from dual

1019: -- Cursor for Regions
1020:
1021: cursor c_region is
1022: select '-1' region_code, ' ' region
1023: from dual
1024: union
1025: select lookup_code region_code, meaning region
1026: from fnd_lookups
1027: where lookup_type = 'REGION'