DBA Data[Home] [Help]

APPS.GMF_COPY_RSRC_COST dependencies on HR_ORGANIZATION_INFORMATION

Line 214: 'hr_organization_information hoi , mtl_parameters mp ' ||

210: l_sql_orgn :=
211: ' SELECT ' ||
212: 'hoi.organization_id ' ||
213: ' FROM ' ||
214: 'hr_organization_information hoi , mtl_parameters mp ' ||
215: ' WHERE ' ||
216: 'hoi.org_information2 = to_char(:pi_legal_entity_id_to) '||
217: ' AND hoi.org_information_context = ''Accounting Information'' '||
218: ' AND hoi.organization_id = mp.organization_id '||

Line 536: AND d.organization_id IN (SELECT a.organization_id FROM hr_organization_information a, mtl_parameters b

532: SELECT COUNT(1)
533: FROM cm_rsrc_dtl d,
534: cr_rsrc_mst m
535: WHERE d.legal_entity_id = p_legal_entity_id
536: AND d.organization_id IN (SELECT a.organization_id FROM hr_organization_information a, mtl_parameters b
537: where a.organization_id = b.organization_id
538: and b.process_enabled_flag = 'Y' and
539: a.org_information2 = p_legal_entity_id
540: and a.org_information_context = 'Accounting Information' )