DBA Data[Home] [Help]

APPS.GMF_CMCOMMON dependencies on HR_ORGANIZATION_INFORMATION

Line 524: FROM hr_organization_information o,

520: SELECT o.organization_id,
521: f.legal_entity_id,
522: f.cost_type_id,
523: f.cost_basis
524: FROM hr_organization_information o,
525: gmf_fiscal_policies f
526: WHERE o.organization_id = v_organization_id
527: AND o.org_information_context = 'Accounting Information'
528: AND o.org_information2 = f.LEGAL_ENTITY_ID

Line 1165: hr_organization_information o

1161: SELECT m.cost_type_id,
1162: m.default_lot_cost_type_id
1163: FROM cm_mthd_mst m,
1164: gmf_fiscal_policies plc,
1165: hr_organization_information o
1166: WHERE o.organization_id = v_organization_id
1167: AND o.org_information_context = 'Accounting Information'
1168: AND plc.legal_entity_id = o.org_information2
1169: AND plc.cost_type_id = m.cost_type_id

Line 1808: FROM hr_organization_information src, hr_organization_information dest

1804: */
1805:
1806: SELECT to_number(src.org_information2) src_ou, to_number(dest.org_information2) dest_ou
1807: INTO l_from_ou, l_to_ou
1808: FROM hr_organization_information src, hr_organization_information dest
1809: WHERE src.organization_id = p_src_organization_id
1810: AND src.org_information_context = 'Accounting Information'
1811: AND dest.organization_id = p_dest_organization_id
1812: AND dest.org_information_context = 'Accounting Information'