APPS.GCS_INTERCO_DYNAMIC_PKG dependencies on GCS_INTERCO_HDR_GT

Line 116: FROM GCS_INTERCO_HDR_GT gihg,

112: giet.Intercompany_id),
113: DECODE(MAX(gim.line_item_group), 2,
114: giet.company_cost_center_org_id,
115: giet.Intercompany_id)
116: FROM GCS_INTERCO_HDR_GT gihg,
117: GCS_INTERCO_ELM_TRX giet,
118: GCS_INTERCO_MEMBERS gim,
119: GCS_CONS_RELATIONSHIPS gcr,
120: FEM_BALANCES fb

Line 204: FROM GCS_INTERCO_HDR_GT gihg,

200: giet.Intercompany_id),
201: DECODE(MAX(gim.line_item_group), 2,
202: giet.company_cost_center_org_id,
203: giet.Intercompany_id)
204: FROM GCS_INTERCO_HDR_GT gihg,
205: GCS_INTERCO_ELM_TRX giet,
206: GCS_INTERCO_MEMBERS gim,
207: GCS_CONS_RELATIONSHIPS gcr,
208: FEM_BALANCES fb

Line 296: FROM GCS_INTERCO_HDR_GT gihg,

292: giet.Intercompany_id),
293: DECODE(MAX(gim.line_item_group), 2,
294: giet.company_cost_center_org_id,
295: giet.Intercompany_id)
296: FROM GCS_INTERCO_HDR_GT gihg,
297: GCS_INTERCO_ELM_TRX giet,
298: GCS_INTERCO_MEMBERS gim,
299: GCS_CONS_RELATIONSHIPS gcr,
300: FEM_BALANCES fb

Line 387: FROM GCS_INTERCO_HDR_GT gihg,

383: giet.Intercompany_id),
384: DECODE(MAX(gim.line_item_group), 2,
385: giet.company_cost_center_org_id,
386: giet.Intercompany_id)
387: FROM GCS_INTERCO_HDR_GT gihg,
388: GCS_INTERCO_ELM_TRX giet,
389: GCS_INTERCO_MEMBERS gim,
390: GCS_CONS_RELATIONSHIPS gcr,
391: FEM_BALANCES fb

Line 480: FROM GCS_INTERCO_HDR_GT gihg,

476: giet.Intercompany_id),
477: DECODE(MAX(gim.line_item_group), 2,
478: giet.company_cost_center_org_id,
479: giet.Intercompany_id)
480: FROM GCS_INTERCO_HDR_GT gihg,
481: GCS_INTERCO_ELM_TRX giet,
482: GCS_INTERCO_MEMBERS gim,
483: FEM_BALANCES fb
484: WHERE giet.cal_period_id = p_cal_period_id

Line 578: FROM GCS_INTERCO_HDR_GT gihg,

574: giet.Intercompany_id),
575: DECODE(MAX(gim.line_item_group), 2,
576: giet.company_cost_center_org_id,
577: giet.Intercompany_id)
578: FROM GCS_INTERCO_HDR_GT gihg,
579: GCS_INTERCO_ELM_TRX giet,
580: GCS_INTERCO_MEMBERS gim,
581: FEM_BALANCES fb
582: WHERE giet.cal_period_id = p_cal_period_id

Line 777: GCS_INTERCO_HDR_GT gihg1,

773: ABS(SUM(NVL(ytd_debit_balance_e,0))-
774: SUM(NVL(ytd_credit_balance_e,0)))))
775:
776: FROM GCS_ENTRY_LINES_GT gel,
777: GCS_INTERCO_HDR_GT gihg1,
778: fem_cctr_orgs_attr fcoa2 ,
779: fem_cctr_orgs_attr fcoa3
780: WHERE gihg1.entry_id = gel.entry_id
781: AND gel.receivables_org_id =

Line 863: GCS_INTERCO_HDR_GT gihg1

859: SUM(NVL(ytd_credit_balance_e,0)), 0,
860: ABS(SUM(NVL(ytd_debit_balance_e,0))-
861: SUM(NVL(ytd_credit_balance_e,0)))))
862: FROM GCS_ENTRY_LINES_GT gel,
863: GCS_INTERCO_HDR_GT gihg1
864: WHERE gihg1.entry_id = gel.entry_id
865: GROUP BY gihg1.entry_id, receivables_org_id, payables_org_id;
866:
867: g_no_rows := NVL(SQL%ROWCOUNT,0);