DBA Data[Home] [Help]

APPS.GCS_AGGREGATION_DYNAMIC_PKG dependencies on GCS_AGGREGATION_PKG

Line 103: sysdate, GCS_AGGREGATION_PKG.g_fnd_user_id,

99: company_cost_center_org_id, line_item_id, intercompany_id,
100: sum(xtd_balance_e), sum(ytd_balance_e),
101: sum(ptd_debit_balance_e), sum(ptd_credit_balance_e),
102: sum(ytd_debit_balance_e), sum(ytd_credit_balance_e),
103: sysdate, GCS_AGGREGATION_PKG.g_fnd_user_id,
104: sysdate, GCS_AGGREGATION_PKG.g_fnd_user_id,
105: GCS_AGGREGATION_PKG.g_fnd_login_id
106: FROM
107: GCS_HIERARCHIES_B ghb,

Line 104: sysdate, GCS_AGGREGATION_PKG.g_fnd_user_id,

100: sum(xtd_balance_e), sum(ytd_balance_e),
101: sum(ptd_debit_balance_e), sum(ptd_credit_balance_e),
102: sum(ytd_debit_balance_e), sum(ytd_credit_balance_e),
103: sysdate, GCS_AGGREGATION_PKG.g_fnd_user_id,
104: sysdate, GCS_AGGREGATION_PKG.g_fnd_user_id,
105: GCS_AGGREGATION_PKG.g_fnd_login_id
106: FROM
107: GCS_HIERARCHIES_B ghb,
108: FEM_BALANCES fb,

Line 105: GCS_AGGREGATION_PKG.g_fnd_login_id

101: sum(ptd_debit_balance_e), sum(ptd_credit_balance_e),
102: sum(ytd_debit_balance_e), sum(ytd_credit_balance_e),
103: sysdate, GCS_AGGREGATION_PKG.g_fnd_user_id,
104: sysdate, GCS_AGGREGATION_PKG.g_fnd_user_id,
105: GCS_AGGREGATION_PKG.g_fnd_login_id
106: FROM
107: GCS_HIERARCHIES_B ghb,
108: FEM_BALANCES fb,
109: GCS_CONS_RELATIONSHIPS gcr,

Line 297: SYSDATE, gcs_aggregation_pkg.g_fnd_user_id, SYSDATE,

293:
294: SUM (xtd_balance_e), SUM (ytd_balance_e),
295: SUM (ptd_debit_balance_e), SUM (ptd_credit_balance_e),
296: SUM (ytd_debit_balance_e), SUM (ytd_credit_balance_e),
297: SYSDATE, gcs_aggregation_pkg.g_fnd_user_id, SYSDATE,
298: gcs_aggregation_pkg.g_fnd_user_id,
299: gcs_aggregation_pkg.g_fnd_login_id
300: FROM gcs_entry_lines_gt
301: GROUP BY entry_id,

Line 298: gcs_aggregation_pkg.g_fnd_user_id,

294: SUM (xtd_balance_e), SUM (ytd_balance_e),
295: SUM (ptd_debit_balance_e), SUM (ptd_credit_balance_e),
296: SUM (ytd_debit_balance_e), SUM (ytd_credit_balance_e),
297: SYSDATE, gcs_aggregation_pkg.g_fnd_user_id, SYSDATE,
298: gcs_aggregation_pkg.g_fnd_user_id,
299: gcs_aggregation_pkg.g_fnd_login_id
300: FROM gcs_entry_lines_gt
301: GROUP BY entry_id,
302: company_cost_center_org_id,

Line 299: gcs_aggregation_pkg.g_fnd_login_id

295: SUM (ptd_debit_balance_e), SUM (ptd_credit_balance_e),
296: SUM (ytd_debit_balance_e), SUM (ytd_credit_balance_e),
297: SYSDATE, gcs_aggregation_pkg.g_fnd_user_id, SYSDATE,
298: gcs_aggregation_pkg.g_fnd_user_id,
299: gcs_aggregation_pkg.g_fnd_login_id
300: FROM gcs_entry_lines_gt
301: GROUP BY entry_id,
302: company_cost_center_org_id,
303: line_item_id,