DBA Data[Home] [Help]

APPS.GMF_SUBLEDGER_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 1529: hr_organization_information hoi,

1525: )
1526: IS
1527: SELECT nvl(SUM(decode(nvl(gpb.period_close_status,'~'),'F',1,'P',1, 0)),0) as close_status
1528: FROM org_acct_periods oap,
1529: hr_organization_information hoi,
1530: mtl_parameters mp,
1531: gmf_period_statuses gps,
1532: gl_ledgers gl,
1533: gmf_period_balances gpb

Line 1689: hr_organization_information hoi,

1685: period_num
1686: INTO x_inv_fiscal_year,
1687: x_inv_period
1688: FROM org_acct_periods oap,
1689: hr_organization_information hoi,
1690: gmf_period_statuses gps,
1691: gl_ledgers gl
1692: WHERE gps.period_id = l_prior_period_id
1693: AND hoi.org_information2 = gps.legal_entity_id