APPS.GCS_DP_DYNAMIC_PKG dependencies on GCS_INTERCO_MAP_DTLS

Line 1406: FROM gcs_interco_map_dtls gimd

1402: fnd_log.STRING (fnd_log.level_statement,
1403: g_pkg_name || '.' || l_api_name,
1404: ' UPDATE gcs_entry_lines gel
1405: SET gel.intercompany_id = ( SELECT intercompany_id
1406: FROM gcs_interco_map_dtls gimd
1407: WHERE gimd.line_item_id = gel.line_item_id
1408: )
1409: WHERE gel.entry_id IN( l_entry_id, l_stat_entry_id, l_proportional_entry_id, l_stat_proportional_entry_id)
1410: AND EXISTS ( SELECT intercompany_id

Line 1411: FROM gcs_interco_map_dtls gimd

1407: WHERE gimd.line_item_id = gel.line_item_id
1408: )
1409: WHERE gel.entry_id IN( l_entry_id, l_stat_entry_id, l_proportional_entry_id, l_stat_proportional_entry_id)
1410: AND EXISTS ( SELECT intercompany_id
1411: FROM gcs_interco_map_dtls gimd
1412: WHERE gimd.line_item_id = gel.line_item_id
1413: );');
1414: END IF;
1415: UPDATE gcs_entry_lines gel

Line 1417: FROM gcs_interco_map_dtls gimd

1413: );');
1414: END IF;
1415: UPDATE gcs_entry_lines gel
1416: SET gel.intercompany_id = ( SELECT intercompany_id
1417: FROM gcs_interco_map_dtls gimd
1418: WHERE gimd.line_item_id = gel.line_item_id
1419: )
1420: WHERE gel.entry_id IN( l_entry_id, l_stat_entry_id, l_proportional_entry_id, l_stat_proportional_entry_id)
1421: AND EXISTS ( SELECT intercompany_id

Line 1422: FROM gcs_interco_map_dtls gimd

1418: WHERE gimd.line_item_id = gel.line_item_id
1419: )
1420: WHERE gel.entry_id IN( l_entry_id, l_stat_entry_id, l_proportional_entry_id, l_stat_proportional_entry_id)
1421: AND EXISTS ( SELECT intercompany_id
1422: FROM gcs_interco_map_dtls gimd
1423: WHERE gimd.line_item_id = gel.line_item_id
1424: );
1425:
1426: END IF;IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure

Line 1991: FROM gcs_interco_map_dtls gimd

1987: fnd_log.STRING (fnd_log.level_statement,
1988: g_pkg_name || '.' || l_api_name,
1989: ' UPDATE gcs_entry_lines gel
1990: SET gel.intercompany_id = ( SELECT intercompany_id
1991: FROM gcs_interco_map_dtls gimd
1992: WHERE gimd.line_item_id = gel.line_item_id
1993: )
1994: WHERE gel.entry_id IN( x_entry_id, x_stat_entry_id, x_prop_entry_id, x_stat_prop_entry_id)
1995: AND EXISTS ( SELECT intercompany_id

Line 1996: FROM gcs_interco_map_dtls gimd

1992: WHERE gimd.line_item_id = gel.line_item_id
1993: )
1994: WHERE gel.entry_id IN( x_entry_id, x_stat_entry_id, x_prop_entry_id, x_stat_prop_entry_id)
1995: AND EXISTS ( SELECT intercompany_id
1996: FROM gcs_interco_map_dtls gimd
1997: WHERE gimd.line_item_id = gel.line_item_id
1998: );');
1999: END IF;
2000: UPDATE gcs_entry_lines gel

Line 2002: FROM gcs_interco_map_dtls gimd

1998: );');
1999: END IF;
2000: UPDATE gcs_entry_lines gel
2001: SET gel.intercompany_id = ( SELECT intercompany_id
2002: FROM gcs_interco_map_dtls gimd
2003: WHERE gimd.line_item_id = gel.line_item_id
2004: )
2005: WHERE gel.entry_id IN( x_entry_id, x_stat_entry_id, x_prop_entry_id, x_stat_prop_entry_id)
2006: AND EXISTS ( SELECT intercompany_id

Line 2007: FROM gcs_interco_map_dtls gimd

2003: WHERE gimd.line_item_id = gel.line_item_id
2004: )
2005: WHERE gel.entry_id IN( x_entry_id, x_stat_entry_id, x_prop_entry_id, x_stat_prop_entry_id)
2006: AND EXISTS ( SELECT intercompany_id
2007: FROM gcs_interco_map_dtls gimd
2008: WHERE gimd.line_item_id = gel.line_item_id
2009: );
2010:
2011: END IF;