APPS.GMF_SUBLEDGER_PKG dependencies on ORG_ACCT_PERIODS

Line 156: l_inv_fiscal_year org_acct_periods.period_year%TYPE;

152: /* Start INVCONV umoogala
153: l_inv_fiscal_year ic_cldr_dtl.fiscal_year%TYPE;
154: l_inv_period ic_cldr_dtl.period%TYPE;
155: */
156: l_inv_fiscal_year org_acct_periods.period_year%TYPE;
157: l_inv_period org_acct_periods.period_num%TYPE;
158:
159: l_subledger_ref_no NUMBER(15) := NULL;
160:

Line 157: l_inv_period org_acct_periods.period_num%TYPE;

153: l_inv_fiscal_year ic_cldr_dtl.fiscal_year%TYPE;
154: l_inv_period ic_cldr_dtl.period%TYPE;
155: */
156: l_inv_fiscal_year org_acct_periods.period_year%TYPE;
157: l_inv_period org_acct_periods.period_num%TYPE;
158:
159: l_subledger_ref_no NUMBER(15) := NULL;
160:
161: l_conc_id NUMBER(15) := 0;

Line 1252: l_inv_fiscal_year org_acct_periods.period_year%TYPE := NULL;

1248: l_co_source VARCHAR2(1);
1249: l_source_selected BOOLEAN;
1250:
1251: l_retstatus VARCHAR2(1);
1252: l_inv_fiscal_year org_acct_periods.period_year%TYPE := NULL;
1253: l_inv_period org_acct_periods.period_num%TYPE := NULL;
1254: l_errbuf VARCHAR2(2000);
1255: l_lot_actual_cost NUMBER := 0;
1256: l_post_cm VARCHAR2(2);

Line 1253: l_inv_period org_acct_periods.period_num%TYPE := NULL;

1249: l_source_selected BOOLEAN;
1250:
1251: l_retstatus VARCHAR2(1);
1252: l_inv_fiscal_year org_acct_periods.period_year%TYPE := NULL;
1253: l_inv_period org_acct_periods.period_num%TYPE := NULL;
1254: l_errbuf VARCHAR2(2000);
1255: l_lot_actual_cost NUMBER := 0;
1256: l_post_cm VARCHAR2(2);
1257:

Line 2051: FROM org_acct_periods oap,

2047: )
2048: IS
2049: SELECT NVL(SUM(DECODE(NVL(gpb.period_close_status,DECODE(oap.open_flag,'Y','~','P')),
2050: 'F',1,'P',1, 0)),0) AS close_status
2051: FROM org_acct_periods oap,
2052: hr_organization_information hoi,
2053: mtl_parameters mp,
2054: gmf_period_statuses gps,
2055: gl_ledgers gl,

Line 2211: FROM org_acct_periods oap,

2207: SELECT period_year,
2208: period_num
2209: INTO x_inv_fiscal_year,
2210: x_inv_period
2211: FROM org_acct_periods oap,
2212: hr_organization_information hoi,
2213: gmf_period_statuses gps,
2214: gl_ledgers gl
2215: WHERE gps.period_id = l_prior_period_id

Line 2372: org_acct_periods d1,

2368: d1.period_year fiscal_year, d1.period_num period,
2369: d1.period_start_date begin_date, d2.schedule_close_date period_end_date
2370: FROM
2371: org_organization_definitions org,
2372: org_acct_periods d1,
2373: org_acct_periods d2
2374: WHERE
2375: org.legal_entity = cp_le_id
2376: AND d2.period_year = d1.period_year

Line 2373: org_acct_periods d2

2369: d1.period_start_date begin_date, d2.schedule_close_date period_end_date
2370: FROM
2371: org_organization_definitions org,
2372: org_acct_periods d1,
2373: org_acct_periods d2
2374: WHERE
2375: org.legal_entity = cp_le_id
2376: AND d2.period_year = d1.period_year
2377: AND org.organization_id = d1.organization_id