DBA Data[Home] [Help]

APPS.GMF_COPY_RSRC_COST dependencies on HR_ORGANIZATION_INFORMATION

Line 212: 'hr_organization_information hr , mtl_parameters mp ' ||

208: l_sql_orgn :=
209: 'SELECT ' ||
210: 'hr.organization_id ' ||
211: 'FROM ' ||
212: 'hr_organization_information hr , mtl_parameters mp ' ||
213: 'WHERE ' ||
214: 'hr.org_information2 = :pi_legal_entity_id_to '||
215: ' and hr.org_information_context = ''Accounting Information'' '||
216: ' and hr.organization_id = mp.organization_id '||

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

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