DBA Data[Home] [Help]

APPS.GCS_INTERCO_DYNAMIC_PKG dependencies on GCS_ENTITY_CCTR_ORGS

Line 1210: GCS_ENTITY_CCTR_ORGS geo,

1206: fcoa2.dim_attribute_numeric_member,
1207: fcca.dim_attribute_numeric_member)
1208: FROM GCS_ENTRY_HEADERS geh,
1209: GCS_ENTRY_LINES gel,
1210: GCS_ENTITY_CCTR_ORGS geo,
1211: GCS_ENTITY_CCTR_ORGS geo1,
1212: GCS_CONS_RELATIONSHIPS gcr,
1213: GCS_CONS_RELATIONSHIPS gcr1,
1214: fem_cctr_orgs_attr fcoa2,

Line 1211: GCS_ENTITY_CCTR_ORGS geo1,

1207: fcca.dim_attribute_numeric_member)
1208: FROM GCS_ENTRY_HEADERS geh,
1209: GCS_ENTRY_LINES gel,
1210: GCS_ENTITY_CCTR_ORGS geo,
1211: GCS_ENTITY_CCTR_ORGS geo1,
1212: GCS_CONS_RELATIONSHIPS gcr,
1213: GCS_CONS_RELATIONSHIPS gcr1,
1214: fem_cctr_orgs_attr fcoa2,
1215: fem_cctr_orgs_attr fcoa3,

Line 1353: GCS_ENTITY_CCTR_ORGS geo,

1349: fcoa2.dim_attribute_numeric_member,
1350: fcca.dim_attribute_numeric_member)
1351: FROM GCS_ENTRY_HEADERS geh,
1352: GCS_ENTRY_LINES gel,
1353: GCS_ENTITY_CCTR_ORGS geo,
1354: GCS_ENTITY_CCTR_ORGS geo1,
1355: GCS_CONS_RELATIONSHIPS gcr,
1356: GCS_CONS_RELATIONSHIPS gcr1,
1357: fem_cctr_orgs_attr fcoa2,

Line 1354: GCS_ENTITY_CCTR_ORGS geo1,

1350: fcca.dim_attribute_numeric_member)
1351: FROM GCS_ENTRY_HEADERS geh,
1352: GCS_ENTRY_LINES gel,
1353: GCS_ENTITY_CCTR_ORGS geo,
1354: GCS_ENTITY_CCTR_ORGS geo1,
1355: GCS_CONS_RELATIONSHIPS gcr,
1356: GCS_CONS_RELATIONSHIPS gcr1,
1357: fem_cctr_orgs_attr fcoa2,
1358: fem_cctr_orgs_attr fcoa3,

Line 1496: GCS_ENTITY_CCTR_ORGS geo,

1492: SYSDATE, g_fnd_user_id,
1493: g_fnd_login_id
1494: FROM GCS_ENTRY_HEADERS geh,
1495: GCS_ENTRY_LINES gel,
1496: GCS_ENTITY_CCTR_ORGS geo,
1497: GCS_ENTITY_CCTR_ORGS geo1,
1498: GCS_CONS_RELATIONSHIPS gcr,
1499: GCS_CONS_RELATIONSHIPS gcr1
1500: WHERE geh.entry_id IN (p_entry_id, p_stat_entry_id)

Line 1497: GCS_ENTITY_CCTR_ORGS geo1,

1493: g_fnd_login_id
1494: FROM GCS_ENTRY_HEADERS geh,
1495: GCS_ENTRY_LINES gel,
1496: GCS_ENTITY_CCTR_ORGS geo,
1497: GCS_ENTITY_CCTR_ORGS geo1,
1498: GCS_CONS_RELATIONSHIPS gcr,
1499: GCS_CONS_RELATIONSHIPS gcr1
1500: WHERE geh.entry_id IN (p_entry_id, p_stat_entry_id)
1501: AND geh.entry_id = gel.entry_id

Line 1583: GCS_ENTITY_CCTR_ORGS geo,

1579: SYSDATE, g_fnd_user_id,
1580: g_fnd_login_id
1581: FROM GCS_ENTRY_HEADERS geh,
1582: GCS_ENTRY_LINES gel,
1583: GCS_ENTITY_CCTR_ORGS geo,
1584: GCS_ENTITY_CCTR_ORGS geo1,
1585: GCS_CONS_RELATIONSHIPS gcr,
1586: GCS_CONS_RELATIONSHIPS gcr1
1587: WHERE geh.entry_id IN (p_entry_id, p_stat_entry_id)

Line 1584: GCS_ENTITY_CCTR_ORGS geo1,

1580: g_fnd_login_id
1581: FROM GCS_ENTRY_HEADERS geh,
1582: GCS_ENTRY_LINES gel,
1583: GCS_ENTITY_CCTR_ORGS geo,
1584: GCS_ENTITY_CCTR_ORGS geo1,
1585: GCS_CONS_RELATIONSHIPS gcr,
1586: GCS_CONS_RELATIONSHIPS gcr1
1587: WHERE geh.entry_id IN (p_entry_id, p_stat_entry_id)
1588: AND geh.entry_id = gel.entry_id

Line 1677: GCS_ENTITY_CCTR_ORGS geo,

1673: SYSDATE, g_fnd_user_id,
1674: g_fnd_login_id
1675: FROM GCS_ENTRY_HEADERS geh,
1676: GCS_ENTRY_LINES gel,
1677: GCS_ENTITY_CCTR_ORGS geo,
1678: GCS_ENTITY_CCTR_ORGS geo1,
1679: GCS_CONS_RELATIONSHIPS gcr,
1680: GCS_CONS_RELATIONSHIPS gcr1,
1681: fem_cctr_orgs_attr fcoa2,

Line 1678: GCS_ENTITY_CCTR_ORGS geo1,

1674: g_fnd_login_id
1675: FROM GCS_ENTRY_HEADERS geh,
1676: GCS_ENTRY_LINES gel,
1677: GCS_ENTITY_CCTR_ORGS geo,
1678: GCS_ENTITY_CCTR_ORGS geo1,
1679: GCS_CONS_RELATIONSHIPS gcr,
1680: GCS_CONS_RELATIONSHIPS gcr1,
1681: fem_cctr_orgs_attr fcoa2,
1682: fem_cctr_orgs_attr fcoa3

Line 1789: GCS_ENTITY_CCTR_ORGS geo,

1785: SYSDATE, g_fnd_user_id,
1786: g_fnd_login_id
1787: FROM GCS_ENTRY_HEADERS geh,
1788: GCS_ENTRY_LINES gel,
1789: GCS_ENTITY_CCTR_ORGS geo,
1790: GCS_ENTITY_CCTR_ORGS geo1,
1791: GCS_CONS_RELATIONSHIPS gcr,
1792: GCS_CONS_RELATIONSHIPS gcr1,
1793: fem_cctr_orgs_attr fcoa2,

Line 1790: GCS_ENTITY_CCTR_ORGS geo1,

1786: g_fnd_login_id
1787: FROM GCS_ENTRY_HEADERS geh,
1788: GCS_ENTRY_LINES gel,
1789: GCS_ENTITY_CCTR_ORGS geo,
1790: GCS_ENTITY_CCTR_ORGS geo1,
1791: GCS_CONS_RELATIONSHIPS gcr,
1792: GCS_CONS_RELATIONSHIPS gcr1,
1793: fem_cctr_orgs_attr fcoa2,
1794: fem_cctr_orgs_attr fcoa3