APPS.GCS_LEX_MAP_API_PKG dependencies on GCS_LEX_MAP_DRV_DETAILS

Line 1783: gcs_lex_map_drv_details dvd,

1779: 'D', 'DATE',
1780: 'V', 'VARCHAR2',
1781: '') column_type_code
1782: FROM gcs_lex_map_columns mc,
1783: gcs_lex_map_drv_details dvd,
1784: gcs_lex_map_derivations d
1785: WHERE d.rule_id = create_param_list.rule_id
1786: AND dvd.derivation_id = d.derivation_id
1787: AND dvd.detail_column_id = mc.column_id)

Line 1928: FROM gcs_lex_map_drv_details dvd,

1924: CURSOR all_lookup_details IS
1925: SELECT lutmc.column_name lut_col_name,
1926: stgmc.column_name stg_col_name,
1927: dvd.detail_constant detail_constant
1928: FROM gcs_lex_map_drv_details dvd,
1929: gcs_lex_map_columns lutmc,
1930: gcs_lex_map_columns stgmc
1931: WHERE dvd.derivation_id = create_lookup_derivation.derivation_id
1932: AND dvd.lookup_column_id = lutmc.column_id

Line 2029: FROM gcs_lex_map_drv_details dvd,

2025: 'F', '''' ||
2026: REPLACE(dvd.detail_constant, '''', '''''') ||
2027: '''',
2028: '') string_action
2029: FROM gcs_lex_map_drv_details dvd,
2030: gcs_lex_map_columns mc
2031: WHERE dvd.derivation_id = create_string_derivation.derivation_id
2032: AND dvd.detail_column_id = mc.column_id (+)
2033: ORDER BY dvd.string_merge_order;

Line 2092: FROM gcs_lex_map_drv_details dvd,

2088: 'C', mc.column_name,
2089: 'S',''''||REPLACE(dvd.detail_constant, '''', '''''')||'''',
2090: 'N',dvd.detail_constant,
2091: '') plsql_parameter
2092: FROM gcs_lex_map_drv_details dvd,
2093: gcs_lex_map_columns mc
2094: WHERE dvd.derivation_id = create_plsql_derivation.derivation_id
2095: AND dvd.detail_column_id = mc.column_id (+);
2096: