APPS.GMF_SUBLEDGER_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 2052: hr_organization_information hoi,

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,
2056: gmf_period_balances gpb

Line 2212: hr_organization_information hoi,

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
2216: AND hoi.org_information2 = gps.legal_entity_id