DBA Data[Home] [Help]

APPS.GCS_RULES_PROCESSOR dependencies on GCS_ENTRY_HEADERS_S

Line 476: gcs_entry_headers_s.nextval,

472: -- get the multiple parents elimination entities
473: CURSOR c_elim_entities(l_end_date Date) IS
474: SELECT fea.dim_attribute_numeric_member elim_entity_id,
475: delta_owned,
476: gcs_entry_headers_s.nextval,
477: geca.currency_code,
478: nvl(precision, 2) precision
479: FROM gcs_cons_relationships gcr,
480: fem_entities_attr fea,

Line 503: gcs_entry_headers_s.nextval,

499: -- get the multiple parents consolidation entities
500: CURSOR c_cons_entities(l_end_date Date) IS
501: SELECT gcr.parent_entity_id,
502: delta_owned,
503: gcs_entry_headers_s.nextval,
504: geca.currency_code,
505: nvl(precision, 2) precision
506: FROM gcs_cons_relationships gcr,
507: gcs_entity_cons_attrs geca,

Line 522: gcs_entry_headers_s.nextval,

518: -- get the multiple parents child entities
519: CURSOR c_child_entities(l_end_date Date) IS
520: SELECT geh.entity_id,
521: delta_owned,
522: gcs_entry_headers_s.nextval,
523: geh.currency_code,
524: nvl(precision, 2) precision
525: FROM gcs_cons_relationships gcr,
526: gcs_entry_headers geh,

Line 3747: Select gcs_entry_headers_s.nextval From dual;

3743:
3744: procedureName varchar(30);
3745:
3746: cursor getEntryId is
3747: Select gcs_entry_headers_s.nextval From dual;
3748: entryId gcs_entry_headers.entry_id%TYPE := -1;
3749:
3750: cursor getADEntryId is
3751: SELECT B.assoc_entry_id

Line 4533: Select gcs_entry_headers_s.nextval From dual;

4529:
4530: procedureName varchar(30);
4531:
4532: cursor getEntryId is
4533: Select gcs_entry_headers_s.nextval From dual;
4534: entryId gcs_entry_headers.entry_id%TYPE := -1;
4535:
4536: errbuf varchar2(100);
4537: retcode varchar2(100);