DBA Data[Home] [Help]

APPS.GMF_CMCOMMON dependencies on HR_ORGANIZATION_INFORMATION

Line 528: FROM hr_organization_information o,

524: SELECT o.organization_id,
525: f.legal_entity_id,
526: f.cost_type_id,
527: f.cost_basis
528: FROM hr_organization_information o,
529: gmf_fiscal_policies f
530: WHERE o.organization_id = v_organization_id
531: AND o.org_information_context = 'Accounting Information'
532: AND o.org_information2 = f.LEGAL_ENTITY_ID

Line 1337: hr_organization_information o

1333: SELECT m.cost_type_id,
1334: m.default_lot_cost_type_id
1335: FROM cm_mthd_mst m,
1336: gmf_fiscal_policies plc,
1337: hr_organization_information o
1338: WHERE o.organization_id = v_organization_id
1339: AND o.org_information_context = 'Accounting Information'
1340: AND plc.legal_entity_id = o.org_information2
1341: AND plc.cost_type_id = m.cost_type_id

Line 1986: FROM hr_organization_information src, hr_organization_information dest

1982: */
1983:
1984: SELECT to_number(src.org_information2) src_ou, to_number(dest.org_information2) dest_ou
1985: INTO l_from_ou, l_to_ou
1986: FROM hr_organization_information src, hr_organization_information dest
1987: WHERE src.organization_id = p_src_organization_id
1988: AND src.org_information_context = 'Accounting Information'
1989: AND dest.organization_id = p_dest_organization_id
1990: AND dest.org_information_context = 'Accounting Information'