APPS.GMF_PERIODCLOSE_PUB dependencies on HR_ORGANIZATION_INFORMATION

Line 95: FROM hr_organization_information

91:
92: l_stmt_num := 5;
93: SELECT org_information2
94: INTO l_legal_entity
95: FROM hr_organization_information
96: WHERE organization_id = p_org_id
97: /** Bug#4496452 ANTHIYAG 08-May-2006 Start **/
98: AND org_information_context = 'Accounting Information';
99: /** Bug#4496452 ANTHIYAG 08-May-2006 End **/

Line 468: FROM hr_organization_information

464: l_stmt_num := 23;
465:
466: SELECT org_information3
467: INTO l_operating_unit
468: FROM hr_organization_information
469: WHERE organization_id = p_org_id
470: AND org_information_context = 'Accounting Information';
471:
472:

Line 760: hr_organization_information hoi

756: SELECT oap.period_year, oap.period_num
757: INTO x_inv_period_year, x_inv_period_num
758: FROM org_acct_periods oap,
759: gmf_period_statuses gps,
760: hr_organization_information hoi
761: WHERE gps.period_id = l_prev_period_id
762: AND gps.legal_entity_id = hoi.org_information2
763: AND hoi.org_information_context = 'Accounting Information'
764: AND oap.organization_id = hoi.organization_id

Line 776: hr_organization_information hoi

772: SELECT SUM(decode(open_flag,'Y',1,'P',1, 0))
773: INTO l_open_periods_cnt
774: FROM org_acct_periods oap,
775: mtl_parameters mp,
776: hr_organization_information hoi
777: WHERE hoi.org_information2 = p_legal_entity_id
778: AND hoi.org_information_context = 'Accounting Information'
779: AND hoi.organization_id = oap.organization_id
780: AND hoi.organization_id = mp.organization_id